Access database connection string

Comersus Version: 709
Database type: Access
Frequency: Permanent issue


I am trying to use an Access database with comersus, I've been having problems connecting to a Godaddy DSN that I have created. I see that others have had the same problem with godaddy. I've asked godaddy to tell me whay makes there system different and how I should fix it, but they were no help. Can anyone tell me what is wrong with the following connection string:

Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "DSN=mydsnname.dsn; UserID=mydsnusername; pwd=mydsnpassord"

Thank you,

Spence

Tags:
One Comment

Add a Comment

Your email address will not be published. Required fields are marked *