Help with connection to dababase.

[John R]

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.

 

[Bob Barrows [MVP]]

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

 

[Frederic]

wow great link. thanks didn't know www.aspfaq.com