Browse
 
Tools Add
Rss Categories
-->

DSN

Reference Number: AA-00722 Created: 2012-09-20 17:44 Last Updated: 2012-10-04 09:19 0 Rating/ Voters

How do I signup for a DSN?

You can signup for a DSN through your Customer Control Panel/

  1. Login at https://manage.myhosting.com

If you have more than one subscription, choose your Windows subscription from the drop down menu from the top right of the page

  1. Click on the Websites tab
  2. Click onto the domain you wish to access
  3. Click on More Tools... and then DSN Management
  4. Click on Add New DSN

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: