I am having a heck of a time connecting to a sql 2000 db - I have done this with the other 3 db servers on my network and keep getting :Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Here is my code in ASP :
StrConn_DECA_RSL = "Provider=SQLOLEDB.1;Data Source=webco-rsl;Initial Catalog=Backup;User ID=sa;Password=decarsl"
'StrConn_DECA_RSL = "Provider=SQLOLEDB.1;Data Source=WEBCO-SQL4;Initial Catalog=Midgard;User ID=sa"
Set Conn_DECA_RSL = Server.CreateObject("ADODB.Connection")
Conn_DECA_RSL.ConnectionTimeout = 6000
Conn_DECA_RSL.CommandTimeout = 6000
Set Conn_DECA_RSL = Nothing
I think I have the