Gettting this error->
My code is->
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/MyWeb/test.asp, line 9
If someone could please guide me in the right direction I would greatly apprieciate it.
myconnection = Server.CreateObject("adodb.connection")
connectionString = "Provider=SQLOLEDB.1;Password=myPwd;Persist Security Info=True;User ID=myId;Initial Catalog=MyTable;Data Source=MyCompName\MyDBINSTANCE"