PDA

View Full Version : http 400 error when testing database connection


redrider321
05-15-2007, 01:53 AM
Hi everyone. I have a problem that is driving me insane!! I'm connecting to an access database using a custom connection script: "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.mappath("/database/abbey.mdb"). When I test the connection is DW i get an http 400 error bad request. I've been around the world it seems with tech support at 1and1 and no solutions found. This is occuring in DW8 and DWCS3.
I am including a screenshot of the error and connections file code. Any help would be soooo appreciated!
RRhttp://www.designerbytes.com/screenshot.jpg

davidj
05-15-2007, 03:28 AM
try a different connection string

set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:database/haley.mdb"

change the source to suit

redrider321
05-15-2007, 01:44 PM
Thanks for the response davidj. Sadly that didn't work either. :( I'm at a loss as to what to do!! This was working. I didn't mess with the site for quite a while and I come back to it and I'm getting this. I can't even tell if it's a dreamweaver issue or server issue. Any other ideas? Has anyone seen this before?
RR