i have the below code to connect the sql server on my asp web application, it is not connecting, it gives me the error,
my db connect
================
Set ObjConn = Server.CreateObject ("ADODB.Connection")
Set ObjRs = Server.CreateObject("ADODB
.Recordset
")
ObjConn.Open "Provider=SQLOLEDB; Data Source=ip address; Initial Catalog=dbname; User Id=testxxx; Password=xxxx;"
ObjRs.ActiveConnection = ObjConn
ERROR
==============
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
/test/staging/includes/dbC
onnect.asp
, line 21
Start Free Trial