Data Source Connection

[projectzer1]

Cheers for getting answering so quickly. i've tried your suggestion, and typed the following...


"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=e:\web\projectzer1\htdocs\database\data.mdb"

but the following error still arises...

The testing server specified for this site doesn't map to http://ftp.projectzerofive.com/_mmserverscripts/mmhttpdb.asp URL. Varify that the URL prefix maps to the root of the site.

It's hard work in the beginning, but I'll get there in the end! Any further thoughts or suggestions are welcome.

Thanks,

Paul

[davidseye]

I don't understand the URL, the ftp part after the http. What is that? Shouldn't it read http://www.projectzerofive.com/_mmserverscripts/mmhttpdb.asp ? At this URL I get a page, but not at the other. I don't know what is making it map to this address without seeing the rest of your code. But that's what you need to work out, I think.

[projectzer1]

Hi, I'm new to asp.net, and are trying to learn how to connect to a microsoft access db through DWMX. I'm currently trying to configure a dataset with a DB (data.mdb).

My connection looks like this:

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source= (ftp.mywebsite.com/database/data.mdb)"

but the path I'm trying to use is being rejected. Does anyone know what the correct path would be. Any suggestions would be much appreciated.

Thanks,

paul

[davidseye]

Try the physical path to the db. Example: "e:\web\...etc,etc". Your physical path is on your Control Panel page under "Server Path".