Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Question Unanswered: Plz, how can I: test.asp -> odbc (dsn) -> remote sql server -> odbc -> test.asp


    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") "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 -->

  2. #2
    Join Date
    Dec 2003
    ConnectionString = "driver={SQL Server}; server=IP of server 2; database=database name; UID=login ID;PWD=password;"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts