access connection with dreamweaver

[alun_owen]

HI

I created a DSN connection using Helm but can't pick it up with DreamWeaver, I keep getting a "HTTP Error Code 403 Forbidden" message.

I've tried creating a custom string:-

connString= "driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\domains\superenigmatix.co.uk\db\ceramics.md b;"

but this gives me the same message.

Any ideas please!!

[Jacob]

d:\domains\superenigmatix.co.uk\db\ceramics.md b

It says 'md b'. There is a space between the 'd' and the 'b'. That is what might be causing the error.

Regards,

Jacob

[alun_owen]

Hi Jacob

Thanks for the quick response.

I've tried taking the space out but I get the same response.

Maybe I should check exactly what I do to get DreamWeaver to see my database.

I've opened the 'Database' panel and opened "create custom connection string' and then I've given the string the name 'ceramics' and then pasted

driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\domains\superenigmatix.co.uk\db\ceramics.md b;

into the 'custom string' box

Have I typed in anything I shouldn't like driver= or the semicolonS

Many thanks
Alun

[Jacob]

It looks ok apart from that space, personally I use DSN-Less connections - less hassle. Do you want either post the code or email/PM it to me? Is it on the web at the moment? If so what is the url?

Regards,

Jacob

[alun_owen]

Sorry just tried this string without the space:

driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\domains\superenigmatix.co.uk\db\ceramics.md b;

and get the same thing.

I could be doing something really dumb like putting this string in the wrong box in DreamWeaver - a DSN-less correction is a 'Custom Connection String' right?!

The database is up there but I will overwrite it later once this is right. All my pages are up with dummy data I just need to replace this with dynamic data from 'ceramics.mdb'. I've manage to create a dynamic site previously but the only thing I had someone else to do was to set up a ODBC DSM link before I created the rest of the site using Dreamweaver to generate the ASP code and then wrote the SQL parts myself.

The url is www.superenigmatix.co.uk.

Regards,
Alun