Dreamweaver - Can't connect to Access database

Author

Can't connect to Access database

Tinbeard

2004-11-16, 6:38 pm

Hello,

I'm totally new to asp.NET so I apologise if I'm a little clueless.

I'm trying to connect to an Access database from Dreamweaver 2004 MX,
everything seems to be fine until I complete the connection string, I then
recieve a 403 - Forbidden error.
I've tried everything I can think of, Cassini seems to be running fine,
Dreamweaver "sees" the server running but no matter what I put into the string
(and even if I leave it totaly blank) I get the same error.

This is the string:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=c:\webs\test\database\test.mdb;
User ID=[username];
Password=[password];

I've run it with the user and password fields deleted but still no joy

In cassini the application path is set to "C:\webs\test" and the server is
http://localhost/webs/test/

I'm using XP home and I'm assuming its a permission problem but I've no idea
where or how to check it correctly, I'd be grateful for any help.

2004-11-16, 6:38 pm

the folder in which the .mdb file resides must be writable for the IIS user since the .ldb file must be written.
Not sure if this is the only problem but at least a start

Tinbeard

2004-11-16, 6:44 pm

I'm using Cassini as the web server on XP home so I'm unable to run IIS.
Cassini seems to have no configuration area except for the application path and
the URL setup. It works fine just displaying pages but I always get the "HTTP
403 Forbidden" error when trying to connect to a database using the Access 2000
template, or any other template for that matter. Infact if I just name the
connection and leave the whole string blank and click the test button I still
get it.
This is driving me mad :frown;