Can't connect Dreamweaver MX to database

I am attempting to connect my site to an Access 2000 database with Dreamweaver MX. The steps seem fairly straightforward, but I can't seem to get a connection.

I have set my document type and testing server as Asp.net C#.

Here is what I have entered in as my connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=e:\web\garberu\htdocs\global.mdb"

My DiscountAsp Control listed my server path as:

e:\web\garberu\htdocs
The global.mdb file is at the root of my site. What am I doing wrong? Any suggestions would be greatly appreciated. Thanks.

 

Correct. I didn't know if it was a good idea to post my actual path. I noticed my URL prefix was entered incorrectly on the testing server. I am now successfully connected. Thanks.
quote:Originally posted by bruce

the path is not correct

e:\web\garberu\htdocs\global.mdb

it should be e:\web\[uesrname]\htdocs\global.mdb. garberu is not your username, i know because all our usernames are 11 chars.



quote:Originally posted by dandu

I am attempting to connect my site to an Access 2000 database with Dreamweaver MX. The steps seem fairly straightforward, but I can't seem to get a connection.

I have set my document type and testing server as Asp.net C#.

Here is what I have entered in as my connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=e:\web\garberu\htdocs\global.mdb"

My DiscountAsp Control listed my server path as:

e:\web\garberu\htdocs
The global.mdb file is at the root of my site. What am I doing wrong? Any suggestions would be greatly appreciated. Thanks.

</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">