connecting to mssql 2000 server - urgent

[lia333]

Hey there!

I need some help connecting to mssql 2000 server. It is on my computer, i. e. it's local, my platform is win xp professional. I have set up user dsn named testDSN which works fine according to "Test Data Source" button. i use the following code for connecting to it:

set con=Server.CreateObject("ADODB.Connection&quot
con.open "DRIVER={SQL Server};DSN=testDSN;Server=\\web\vrcserver;UID=sa;PWD="

but it gives me the following mistake:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

if you have any suggestions, please let me know.

Lia

 

[ehsant]

Hi ...
ok, you can use localhost or 127.0.0.1 for the server address .
----
TNX.
E.T.