more than 1 dsns?

Results 1 to 2 of 2

Thread: more than 1 dsns?

  1. #1
    Join Date
    Dec 1969

    Default more than 1 dsns?

    Hi all,<BR>I need to connect to 2 databases at the same time but I&#039;m not sure how the code works.. I have 2 DSNs<BR>Can I do this:<BR>set cn=Server.CreateObject("ADODB.connection")<BR>set rs=Server.CreateObject("ADODB.Recordset")<BR>cn.Op en "DSN=db1"<BR>cn.Open "DSN=db2"<BR>Thanks for your help?<BR>

  2. #2
    HypoCrit Guest

    Default RE: more than 1 dsns?

    Yes you can, but not bu using the same Connection object. You&#039;d have to use two separate instances of the connection object and then open each of them with their respective DSNs.

Posting Permissions

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