DB Connection string help needed..

[Frank]

My hosting service wants me to use a Custom connection in my global.asa
and provided the following - which does not work:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=URL=" & Server.MapPath
("data/schedule.mdb") & "

THe error msg is Unterminated string....

They have not responded with a correct string and I am "shut down".
Any help apperciated,
Frank

PS for years the "old way" of pointing directly to a folder and file on
the web seemed to work fine - But they wanted this change.

 

[David Berry]

The error message is because you have too many double quotes in the string.
It should look like this:

"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath(".") & "\data\schedule.mdb;"

As a reference, you can find all different types of connection strings at
http://www.carlprothman.net/Technology/ConnectionStrings/OLEDBProviders/tabid/87/

 

[Frank]

Now I know why they call you guys MVP's.
Have good data connections now.
(Still waiting to hear from my hosting service}

 

[David Berry]

Glad to help!