I have my site hosted with 1and1 and when testing the database connection I'm getting a "http 400 error bad request" error. This is occuring in DW 8 and CS3. I'm using asp vbscript and connecting with a dsn-less connection. I've tried different connection strings, etc. I've attached a screenshot of the error, the connection string, and the connection file. I've been around and around with tech support with this and have gotten nowhere. Not sure if it's a DW issue or a server issue. I really need help on this one!! TIA!!

<img src="www.designerbytes.com/screenshot.jpg" border=0>

Yes I have the same problem. Whats interesting is that when I load a sample shoe site from WebAssist and publish it to the test server that has IIS 6.0, the connection works. If I use OLEDB to specify the connection string to connect to an SQL Server 2005, it also works. This is the code:
"Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=ServerName;Initial Catalog=Database;User ID=SQLUSER;Password=password"

It just seems to be Dreamweaver 8 is not getting the syntax right when I specify the connection string "Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\mydatabase.mdb" using the test server DSN as its source.

Nothing in the Adobe site about this problem that I can find. Trying to contact Adobe for support is next to impossible too

Actually I stand to be corrected, the oledb connection works if I use the client's drivers, if I try to use the test server, I get the http 400 error

I finally solved the problem. Its Dreamweaver settings. If you were to go to the Site Settings under Test Server, change the URL Prefix to one that is the same as the ftp host. Eg if the ftp host was 192.168.1.1 then the url prefix should also be 192.168.1.1