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;server=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 PROTECTED]
