two dsn's

Results 1 to 2 of 2

Thread: two dsn's

  1. #1
    Join Date
    Dec 1969

    Default two dsn's

    Can there be two dsn&#039s on a website. One connecting to an sql databse and the other to an access. I have a site that is running off a sql databse, but now I want to add a webstore which requires an access database. Can this be done. Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: two dsn's

    Sure.<BR>set mySqlConn=Server.CreateObject("ADODB.Connection")< BR>mySqlConn.Open &#039 SQL dsn,password here<BR><BR>set myAccessConn=Server.CreateObject("ADODB.Connection ")<BR>myAccessConn.Open &#039Access DSN here<BR><BR>Just remember which to use when executing.

Posting Permissions

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