DSN

From myhosting.com Wiki

Jump to: navigation, search

How can I use my DSN?

You have to put the following two lines of code in your script to create a database connection using DSN.

Set myconn = Server.CreateObject("ADODB.Connection")
myconn.open "dsn_name","",""

NOTES:

  1. DSN should be registered.
  2. dsn_name = Use your own DSN name.
  3. Database must be under the /fpdb or /cgi-bin directories(for Windows 2003 servers).
Personal tools