Jet.OLEDB Conn to ADO.DB Conn

[cepot]

Hi,
I'm newbie to ASP
I used to use this connection string to connect my asp script to mdb in Localhost:

-----------------------------------------
my_connection_file.asp:

Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("/somewwwfolder/db/mydatabase.mdb")&";Persist Security Info=False"
-----------------------------------------

it is worked in my localhost.
then now I put the script in some free asp host, all file uploaded, but somehow when i run .asp file, got error in the connection string.
after read the hoster faq, it stated to

related FAQ
How do I connect to my MS Access database?
Make sure your database is in the "db" directory in your file space.
Here is a sample ASP code to connect to a MS Access database.

Set Conn = Server.CreateObject("ADODB.Connection")
strConnection = "DRIVER=Microsoft Access Driver(*.mdb);DBQ=" & Server.MapPath("/USERNAME/db/yourdatabase.mdb")

so my Question is, how do you make a db connection from my_connection_file.asp to become a connection db string as related hoster faq?

thanks in advance,
cepot

[webber123456]

just use the example they provided and you should be ok

Set Conn = Server.CreateObject("ADODB.Connection")
strConnection = "DRIVER=Microsoft Access Driver(*.mdb);DBQ=" & Server.MapPath("/USERNAME/db/yourdatabase.mdb")

[Doug G]

Also you probably can use the more robust OLEDB driver if you modify the connection string you started with to the proper path to the .mdb. You can find examples of connection strings at connectionstrings.com

[siteguru]

Is this hosted at Brinkster by any chance?

You may find my tutorial here of some use.

[cepot]

@all : thanks for helping. It just solved by moving to other paying asp hosting. i guess it was caused of some restriction of include file .inc (Global Asa something, according Microsoft Knowledge sort of). anyway thanks for helping guys.

@webber: I did use the example hoster provide, and its not worked so i came here to asked about it.

@Doug: yes, i put in the connection string valid path & file name

@siteguru: no, it isn't sire. its other free hosting.