PDA

View Full Version : test database connection error


JoeBurns
03-12-2006, 03:47 PM
I'm trying to use Dreamweaver to set up a database connection using a custom connections string. I know I have the correct file path:

sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.0.0.105\go2relay.com\public\bookstore\ fpdb\vsproducts.mdb;"

I'm using it already for another application and it works fine. This is what the connection looks like that I'm now using:

<%
DIM sDSN
sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.0.0.105\go2relay.com\public\bookstore\ fpdb\vsproducts.mdb;"
%>

When I set it up using dreamweaver it creates this:
<%
Dim MM_testconn_STRING
MM_testconn_STRING = sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.0.0.105\go2relay.com\public\bookstore\ fpdb\vsproducts.mdb;"
%>

which includes the name of the connection "testconn"

When I test the connection I get this error message:

"HTTP error code 415 unsupported media type"

Thanks

mar0364
03-12-2006, 06:33 PM
I've been using ASP and access databases for while and have never had that happen. I googled it and came up with some refreances to SOAP. Have you tried deleteing it and trying it again?

Rich

JoeBurns
03-12-2006, 07:01 PM
I've tried several times. I wasn't sure whether or not that whole line (below) should be entered into the custom string dialog box.

sDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\10.0.0.105\go2relay.com\public\bookstore\ fpdb\vsproducts.mdb;"

That's what I've been doing.

mar0364
03-13-2006, 12:39 PM
Here is a good bit on ccs.

http://www.webthang.co.uk/tuts/tuts_ud4/ue6/ue6_4.asp

JoeBurns
03-13-2006, 12:43 PM
Thanks. I'll check it out.