Activate Access DSN

To order a DSN connection for your Access or FoxPro database, you will need to specify a name for the DSN connection and the name of the database. Depending on your Windows hosting plan, there may or may not be a charge.  The DSN and database names must be between 2 and 14 characters and can contain only lowercase letters, numbers and hyphens.

 

To order a Microsoft Access DSN

1

Prior to creating a DSN, you must first upload the appropriate Access database file to the server.  For instructions, please click here.  Once a database is uploaded, then proceed to Step 2.

2

Log in to ControlPanel and click Website.   

3

Under the Currently Managing drop-down list, make sure the proper Windows hosting domain is selected.  
Scroll down to the Added Functionality section and click DSN (Data Source Name).

4

Click the Activate button in the Activate Access DSN box.

 

5

Now enter the name you wish to use for the DSN and select its corresponding Access database (that you already uploaded in Step 1 above).

Depending on your hosting plan, there may or may not be a charge for Access DSN.  Please refer to your plan details for further information.  If there is a charge, you will be asked to confirm the charge after clicking on the Purchase button above.

6

You should now see the confirmation page.

 

 

Using DSN connections

You may need this information when you connect to your database using a DSN connection.

 

Microsoft Access DSN connection strings

Without a password

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>

With a password

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname","username","password"
%>