Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.<BR><BR>I coded:<BR>set cn=server.createobject("ADODB.Connection")<BR>cn.o pen "confidsqlserver"<BR><BR>which confidsqlserver is the dsn in ODBC.
Then there is a problem with the DSN. Open it back up (In the ODBC control panel) and make sure that everyting is correct. There is also a button there, that allows you to test the connection....keep trying it, until you get the properties right.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.<BR><BR>the sql server is on another system though. The connectivity is working fine though. I think need a statment to log into the system is it?<BR>