Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Help with connection to dababase.

Reply
Thread Tools

Help with connection to dababase.

 
 
John R
Guest
Posts: n/a
 
      09-20-2004
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'kingkong'. Reason: Not associated with a
trusted SQL Server connection.
/samples/db_paged_search.asp, line 84

below is my connection string.

cnnSearch.Open "Provider=SQLOLEDB;Data Source=192.168.1.100;" _
& "Initial Catalog=testdbs;User Id=userid;Password=password;" _
& "Connect Timeout=15;Network Library=dbmssocn;"
I am currently using a windows account instead of sql server.
 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      09-20-2004
John R wrote:
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80004005)
> Login failed for user 'kingkong'. Reason: Not associated with a
> trusted SQL Server connection.
> /samples/db_paged_search.asp, line 84
>
> below is my connection string.
>
> cnnSearch.Open "Provider=SQLOLEDB;Data Source=192.168.1.100;" _
> & "Initial Catalog=testdbs;User Id=userid;Password=password;" _
> & "Connect Timeout=15;Network Library=dbmssocn;"
> I am currently using a windows account instead of sql server.


Your error is covered in this article:
http://www.aspfaq.com/show.asp?id=2009

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


 
Reply With Quote
 
 
 
 
Frederic
Guest
Posts: n/a
 
      09-21-2004
wow great link. thanks didn't know www.aspfaq.com

--
Frederic
MCP, IT Project+, i-Net+, CIW Associate, A+
----------------------------------------------------------------------------
http://fredsfastcram.netfirms.com
----------------------------------------------------------------------------

"Bob Barrows [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> John R wrote:
> > Error Type:
> > Microsoft OLE DB Provider for SQL Server (0x80004005)
> > Login failed for user 'kingkong'. Reason: Not associated with a
> > trusted SQL Server connection.
> > /samples/db_paged_search.asp, line 84
> >
> > below is my connection string.
> >
> > cnnSearch.Open "Provider=SQLOLEDB;Data Source=192.168.1.100;" _
> > & "Initial Catalog=testdbs;User Id=userid;Password=password;" _
> > & "Connect Timeout=15;Network Library=dbmssocn;"
> > I am currently using a windows account instead of sql server.

>
> Your error is covered in this article:
> http://www.aspfaq.com/show.asp?id=2009
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
No "Wireless Network Connection" available in network connection =?Utf-8?B?am9raW5kYTE=?= Wireless Networking 7 10-16-2012 07:32 AM
ICS works with wired connection, fails with wireless connection Rich Wireless Networking 0 11-16-2005 06:48 PM
Wireless Connection drops / PS2 connection Steve Wireless Networking 1 07-27-2005 01:27 PM
Not seeing Wireless Connection in Network Connection =?Utf-8?B?bW90b21hbm1hdHQ=?= Wireless Networking 4 03-05-2005 04:39 AM
Re: Share/join 2 connection to 1 connection - Pls help d4n13l MCSE 6 04-21-2004 08:57 AM



Advertisments