Connection string problem

Hi.

I am using the server map path function in DWMX04 to set up a connection string to an Access database (stored locally) but on the same path as the online version. This is what I get in the Connection file.

Dim MM_connLocal_STRING
MM_connLocal_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("cgi-bin/localtest.mdb")


DW tells me that it is unable to retrieve any tables from the database, yet it still works locally and on the web. When I test the connection in the 'Define' part, it connects OK. Any ideas? I am using WinXP Pro (SP2).

Thanks. Jim

You might get a better visibility for this on the appdev forum.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Jim" <jim.mills (AT) dsl (DOT) pipex.com> wrote

Hi.

I am using the server map path function in DWMX04 to set up a connection
string to an Access database (stored locally) but on the same path as the
online version. This is what I get in the Connection file.

Dim MM_connLocal_STRING
MM_connLocal_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("cgi-bin/localtest.mdb")


DW tells me that it is unable to retrieve any tables from the database, yet
it still works locally and on the web. When I test the connection in the
'Define' part, it connects OK. Any ideas? I am using WinXP Pro (SP2).

Thanks. Jim