http 400 error

[redrider321]

I'm trying to create a dsn-less connection to 1and1.com. I'm using the custom connection string,
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/ourhaley.com/database/haley.mdb") & ";"
I'm getting the error "http error code 400 bad request"
I've been around and around with support to no avail.
Any thoughts anyone?

[Newsgroup_User]

Try backslashes instead of forward slashes:

"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\ourhaley.com\database\haley.mdb") & ";"

http://www.communitymx.com/content/article.cfm?page=1&cid=A6D0B2B03FC484DB

--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com

"redrider321" <webforumsuser@macromedia.com> wrote in message news:f169hn$grm$1@forums.macromedia.com...
> I'm trying to create a dsn-less connection to 1and1.com. I'm using the custom
> connection string,
> "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
> Server.MapPath("/ourhaley.com/database/haley.mdb") & ";"
> I'm getting the error "http error code 400 bad request"
> I've been around and around with support to no avail.
> Any thoughts anyone?
>

[redrider321]

Thanks for the quick response Ken. Sadly I have tried that and just tried it again and still getting the same error. Any other ideas?
Mike

[Newsgroup_User]

Use a Jet OleDb connection string to connect to access, it gives better
performance and is also DSN less

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/ourhaley.com/database/haley.mdb") & ";Persist Security
Info=False"



"redrider321" <webforumsuser@macromedia.com> wrote in message
news:f169hn$grm$1@forums.macromedia.com...
> I'm trying to create a dsn-less connection to 1and1.com. I'm using the
> custom
> connection string,
> "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
> Server.MapPath("/ourhaley.com/database/haley.mdb") & ";"
> I'm getting the error "http error code 400 bad request"
> I've been around and around with support to no avail.
> Any thoughts anyone?
>

[redrider321]

Okay now we seem to be making some progress. I'm getting a different error message at least!! Now the error message is "Format of the iniitialization string does not conform to the OLE DB specification". I tried to copy and paste the string from you message but it would only copy one line at a time so I'm not sure if I have spaces where they need to be, etc. This is the string as it is in Dreamweaver: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
" & Server.MapPath("/ourhaley.com/database/haley.mdb") & ";Persist Security Info=False"

[redrider321]

Not paying attention. I got the above error when I test on local machine. Testing on remote server yields same error as before. http 400 error bad request. 😞

[Alsct]

I have two websites on dfferent servers and in both cases my connection string is "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/database/mymdb.mdb")
ie. without /ourhaley.com/ and no final &";"

You can but try.

[redrider321]

Thanks for the response Alsct, but it didn't help. Same error! This is driving me insane!! Any recommendations for good inexpensive hosting??