PDA

View Full Version : Can't connect Dreamweaver MX to database


dandu
08-07-2003, 09:51 AM
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.

bruce
08-08-2003, 01:15 AM
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.



[b]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">

dandu
08-08-2003, 05:20 AM
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.
[b]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.



[b]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">