problem defining a custom connection string

[singh83]

Hi,
could someone please help with a problem I am having. When I try to create a
connection string using DW's custom connection string dialog/interface I get an
error.

The string I typed is:
"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("bugdb.mdb")

Error I get:
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry
key 'Temporary (volatile) Jet DSN for process 0x10cc Thread 0xa84 DBC
0x12295254 Jet'.

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry
key 'Temporary (volatile) Jet DSN for process 0x10cc Thread 0xa84 DBC
0x12295254 Jet'.

[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

I would really appreciate if somebody could help me out.
Thanks,
Sarb.

[Nancy Gill]

> The string I typed is:

> "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &

Server.MapPath("bugdb.mdb")


try this string instead:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.Mappath("\foldername\bugdb.mdb") & ";"


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

[singh83]

Hi,
I tried the new string and it did not work. I got the following error msg:

Could not find file 'd:\user\tlbugtracker\_mmServerScripts\bugdb.mdb

The exact string i typed was:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.Mappath("bugdb.mdb") +
";"

I changed '&' to '+' as i'm using javascript not vbscript.

Is there anything else I can try??

Thanks very much,

Sarb.