Hello folks

I,m trying to transfer a website with a small database(asp.) from a free asp hosting to the clients hosting. The problem i have is that when uploading the site to client hosting the database will not work, i was informed it was an issue with the connection string. I tried a few variations but could not get it to work, customers is wanting site badly, this is the only element of the site i cannot get to work.

Please find below the current connection string for the free hosting, this works.

I would be grateful for some advise on this matter.

Regards

GOING Insane

<%

Dim vPath, pPath, ConString
vPath = "database\finegreen.mdb" 'use this one if database is in root of cart folder
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDBatabase Password=foo"
%>

The connection string looks fine from here. The only things I can think you can do are to remove the database password (just to see if that solves the problem) and to make sure your finegreen.mdb file is in the database subdirectory of your client site.

Yeah it seems your very cool geezer

Again thanks for your help, speak to you soon

Site is up and running

insane