here is my full code......
the error is.....
Microsoft OLE DB Provider for SQL Server: Cannot open database "pubs"
requested by the login. The login failed....
in the line with huge text......
<%
Dim oCmd
Dim oCn
Dim oRs
Dim sConn
Dim sProvider
sConn= "Provider=SQLOLEDB;Integrated
Security=SSPI;Trusted_Connection=yes;Initial Catalog=pubs;Connect
Timeout=0;Data Source=VIVEK-PC"
Set oCn = Server.CreateObject("ADODB.Connection")
oCn.ConnectionString = sConn
oCn.Open
If oCn.errors.count = 0 Then
Response.Write "Connected OK"
Else
Response.Write "NOT Connected OK"
End If
Set oCmd = CreateObject("ADODB.Command")
Set oCmd.ActiveConnection = oCn
oCmd.CommandText = "select * from him"
oCmd.CommandType = 1
Set oRs = oCmd.Execute()
oCn.close
oRs.Close
%>
On Mon, Sep 12, 2011 at 4:19 PM, Sanjay Rajpal <[email protected]> wrote:
> Same is available in VB also.
>
>
> Sanju
> :)
>
>
>
> On Mon, Sep 12, 2011 at 3:46 AM, himanshu kansal <
> [email protected]> wrote:
>
>> i have that book....:P:P
>> is there any other good book relating to VB.....
>>
>> On Mon, Sep 12, 2011 at 4:15 PM, Sanjay Rajpal <[email protected]>wrote:
>>
>>> Apress Beginnin ASP.NET <http://asp.net/> in C# 4.0.
>>>
>>>
>>> Sanju
>>> :)
>>>
>>>
>>>
>>> On Mon, Sep 12, 2011 at 3:40 AM, himanshu kansal <
>>> [email protected]> wrote:
>>>
>>>> okk...i will post the connection string soon....but can anyone tell
>>>> me the name of a good book on asp .net 3.5 for a newcomer.....
>>>> i am new to asp....
>>>> it would be very great if someone could also provide the link of the
>>>> book here......'
>>>> thanx in advance.....
>>>>
>>>> On Mon, Sep 12, 2011 at 1:05 PM, Sanjay Rajpal <[email protected]>wrote:
>>>>
>>>>> Post ur connection string here.
>>>>>
>>>>>
>>>>> Sanju
>>>>> :)
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Sep 12, 2011 at 12:24 AM, himanshu kansal <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> I established a connection to a database in sql server 2008 through
>>>>>> asp.....
>>>>>> the connection string is ok.....
>>>>>> i have checked it and even i have generated the connection from data
>>>>>> link object and used that string....
>>>>>> but the error occurs"login failed for database pubs failed...unable to
>>>>>> login...."
>>>>>>
>>>>>> i am using windows authentication mode.....
>>>>>>
>>>>>> can this be a problem of database security....can anybody tell me how
>>>>>> to tackle with this problem......
>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "Algorithm Geeks" group.
>>>>>> To post to this group, send email to [email protected].
>>>>>> To unsubscribe from this group, send email to
>>>>>> [email protected].
>>>>>> For more options, visit this group at
>>>>>> http://groups.google.com/group/algogeeks?hl=en.
>>>>>>
>>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "Algorithm Geeks" group.
>>>>> To post to this group, send email to [email protected].
>>>>> To unsubscribe from this group, send email to
>>>>> [email protected].
>>>>> For more options, visit this group at
>>>>> http://groups.google.com/group/algogeeks?hl=en.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Regards
>>>> Himanshu Kansal
>>>> Msc Comp. sc.
>>>> (University of Delhi)
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Algorithm Geeks" group.
>>>> To post to this group, send email to [email protected].
>>>> To unsubscribe from this group, send email to
>>>> [email protected].
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/algogeeks?hl=en.
>>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Algorithm Geeks" group.
>>> To post to this group, send email to [email protected].
>>> To unsubscribe from this group, send email to
>>> [email protected].
>>> For more options, visit this group at
>>> http://groups.google.com/group/algogeeks?hl=en.
>>>
>>
>>
>>
>> --
>>
>> Regards
>> Himanshu Kansal
>> Msc Comp. sc.
>> (University of Delhi)
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Algorithm Geeks" group.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected].
>> For more options, visit this group at
>> http://groups.google.com/group/algogeeks?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Algorithm Geeks" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/algogeeks?hl=en.
>
--
Regards
Himanshu Kansal
Msc Comp. sc.
(University of Delhi)
--
You received this message because you are subscribed to the Google Groups
"Algorithm Geeks" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/algogeeks?hl=en.
