Waaaahhhooooooo it worked :-D Thank you so much!
-----Original Message----- From: Hohimer, Christopher J [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 2:10 PM To: ActiveServerPages Subject: RE: sql server connection question Oooooooooooh ok I'll try that. Once in the testing I added that line and it yelled at me so I'll try again :-) -----Original Message----- From: Erik Petersen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:07 PM To: ActiveServerPages Subject: RE: sql server connection question Try configuring your sql client library on your webserver to connect to the server using TCP/IP or force the connection string to use TCP/IP. My syntax could be wrong, but something like this: library=Dbmssocn If the sql server is configured to only listen for TCP you'll get this error. Erik >-----Original Message----- >From: Hohimer, Christopher J [mailto:[EMAIL PROTECTED]] >Sent: July 25, 2002 2:22 PM >To: ActiveServerPages >Subject: RE: sql server connection question > > >Microsoft OLE DB Provider for SQL Server error '80004005' > >[DBNMPNTW]ConnectionOpen (CreateFile()). > >The error 80004005 corresponds to a failed login (or so I think I >found that >on a website) > >Chris > > >-----Original Message----- >From: Shawn Berg [mailto:[EMAIL PROTECTED]] >Sent: Thursday, July 25, 2002 12:20 PM >To: ActiveServerPages >Subject: RE: sql server connection question > >Copy and paste the error so we can see exactly what it says. > >Shawn > >-----Original Message----- >From: Hohimer, Christopher J [mailto:[EMAIL PROTECTED]] >Sent: Thursday, July 25, 2002 12:20 PM >To: ActiveServerPages >Subject: sql server connection question > > >I'm trying to get a "web application" to interface with our sql database >across the network. I get a login error when click "check" >Here is my code. I have talked to the database guy and he says that the >username, password, and server are correct. My question is are the >containters "username" "password" set somewhere or are they >specific for the >asp syntax and if so am I using them right. A website I was looking at used >UID= and PWD= so I'm a little confused. If I'm being horrendously confusing >let me know and I'll try and reword the question. ><% >set conn = Server.CreateObject("ADODB.Connection") > >strConn="Provider=SQLOLEDB;username=MYUSERNAME;passwd=MYPASSWORD;se >rver=xxx. >xxx.xxx.xxx;database=MYDATABASE" > >conn.ConnectionTimeout = 15 >conn.CommandTimeout = 10 >conn.ConnectionString = strConn >conn.Open > >if conn.errors.count = 0 then > response.write "Connected OK" >end if > >conn.Close >%> > >Thanks >Chris Hohimer >Sandia National Laboratories >CSU821 ORG9623 > > >--- >You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >%%email.unsub%% > > >--- >You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >%%email.unsub%% > > >--- >You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >%%email.unsub%% > --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
