Browse
 
Tools Add
Rss Categories
-->

DSN

Reference Number: AA-00226 Created: 2012-09-19 17:49 Last Updated: 2012-10-02 05:58 0 Rating/ Voters

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).
Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: