DSN (or DSN-less) connection help - goDaddy host

[Howard_Latimer1]

Trying to pass data from a form to an Access DB, using ASP.  goDaddy is the hosting company. A DSN connection can be created thru the hosting Control Panel, but the connection string is placed in a hidden folder (called "_dsn") - I don't know if there is a method within DW to "find" that hidden folder. Alternatively, I have tried to create a DSN-less connection, but I continue to get errors.

I know the physical path by using the MapPath method. The string I came up with looks like this:

Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\Hosting\6275499\html\access_db\MDC_Comment_Database.mdb

The root directory is D:\Hosting\6275499\html

The page is at D:\Hosting\6275499\html\db_test.asp

Any assistance or insights would be greatly appreciated. I don't have much hair left to pull out.

[Howard_Latimer1]

OK - I figured it out, in case anyone else out there has these same issues. When creating a custom connection string in DW, the code is all on one line. I interpreted very literally from the DW help that the connection string is set up on two lines:

Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\Hosting\6275499\html\access_db\MDC_Comment_Database.mdb

But the only the first line of code is pasted into the DSN field. However, when I went back and looked at it, the second line was not in the field. By making it one long string:

Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\Hosting\6275499\html\access_db\MDC_Comment_Database.mdb

the form could connect with the table. (NOTE: when posting this line of code above, it will probably look like two lines, but it really should just be one long line.)

Hope this helps - maybe Adobe could make a notation of that in the Help area that the string should be one line.