Connecting to MSAccess database using ASP

The Microsoft Access database server is located on our internal network, which means that there is no external access to this server.

NOTE: DSNless connections are NOT supported on account of the above.

Connection to the server is made using a DSN string. Below is a sample connection code using ASP web development language:

connStr = "DSN=aspmdb;Database=\\kramer\aspsamba\domain_com_au.mdb;UID=user;PWD=pass"

'Create the Connection Object

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.ConnectionTimeout = 30

Conn.CommandTimeout = 30

'Open the Connection object

Conn.Open connStr

When the database is enabled for you by our staff and you have uploaded the file according to the instructions we provide with confirmation, you will be able to view the DSN string with the above sample code via The Console's Database section. It will include the appropriate values for Database=, UID= and PWD=.

Related topics

• Frontpage and MsAccess
• How to enable
• FAQ