Hi,

I'm trying to connect using DSN in a remote sql server.

does anybody know what i am suposed to do?

i mean, i would like to know, how can i connect to a remote sql server using dsn.


SERVER 1 has:
test.asp and ODBC.

SERVER 2 has:
sql server.

how can i do:
test.asp -> odbc -> sql server -> odbc -> test.asp

i've tryed to connect using:

set connection = Server.CreateObject("ADODB.Connection")
connection.open "dsn", "user", "pass"

but i think that i must use a diferent port XXXX (because they (boss) have changed this) but i dont know how to specify this.

Thanks a lot.

<!-- Hamiseixas -->

ConnectionString = "driver={SQL Server}; server=IP of server 2; database=database name; UID=login ID;PWD=password;"