remote DSN connections

Results 1 to 2 of 2

Thread: remote DSN connections

  1. #1
    JohnH Guest

    Default remote DSN connections

    Ive been happily writing asp pages using DSN-less connections to access databases residing on the same server as my pages - now i have to connect remotely to a DB2 database using a system DSN - does anyone know how to do this? here is my (nonfunctional ) code so far.<BR><BR>Set conn=Server.CreateObject("ADODB.Connection")<BR>co nn.Open "DSN=odbc:db2://<BR>[remote IP here]<BR>/TEST", "admin", "admin"<BR><BR>sqlstmt = "Select * from COFFEE where CO_ROAST=&#039Dark&#039"<BR>Set rs = conn.Execute(sqlstmt)<BR>

  2. #2
    cinci Guest

    Default RE: remote DSN connections

    the Connection string should be:<BR><BR>conn.Open "Provider=MS Remote;" & _ <BR> "Remote Server=http://serverIP;" & _<BR> "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR> "Data Source=somepathmydb.mdb;", _<BR> "admin", ""<BR><BR>

Posting Permissions

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