Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   Help with connection to dababase. (http://www.velocityreviews.com/forums/t796405-help-with-connection-to-dababase.html)

John R 09-20-2004 04:59 PM

Help with connection to dababase.
 
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] 09-20-2004 05:33 PM

Re: Help with connection to dababase.
 
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.



Frederic 09-21-2004 01:49 AM

Re: Help with connection to dababase.
 
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]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23HIGnfznEHA.3564@tk2msftngp13.phx.gbl...
> 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.
>
>





All times are GMT. The time now is 03:54 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.