hi
I need very urgent help.

I'm having trouble with connecting odbc on remote server, I get error following error : "sql server does not exist or access denied"
I didn't set any username or password on server odbc.

here's my code:

CString = "Provider=MSDASQL;FileDSN=D:\Temporary Files\Temp Project\Test.dsn;"
DBcon.Open CString

Here's my dsn:

[ODBC]
DRIVER=SQL Server
WSID=MOHAMMAD
APP=Microsoft Open Database Connectivity
SERVER=ALIREZA
ADDRESS=192.168.0.2


Any help is highly appreciated
S. Mohammad Najafi

PS : Error when I want to add the same thing =

Microsoft SQL Server ODBC Driver Version 03.85.1022

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

TESTS FAILED!