connecting to database/custom connection

[joeburns]

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

 

[Cheech]

When using DW connections let it do its own stuff. Just change the connection code back to

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

[Peace][Pipe]

 

[joeburns]

I tried it. Still getting the same error message. Thanks for your help.

 

[dodge20]

What type of server are you using? Doesn't sound like they support that connection.

Error Message: "415 – Unsupported Media Type"

Translation: The Web server determines that the client (browser) is requesting a URL resource, but the actual media is not fully compatible with the request. This often occurs during a data transfer between the Web server and client. For example, if you're uploading a file to the Web server using a method that the Web server isn't prepared to accept, a 415 error is usually returned.

Solution: This error is typically due to configuration or programming errors on the Web server end. The Web server will need to be reconfigured to accommodate the media request or method. You should contact the Webmasters of offending sites to make them aware of the trouble.

Dodge20

 

[joeburns]

It's a windows server. Like I said, I'm using the connection string now for another application I've set up. (sample above)It's connecting to the database and working fine.

I just wanted to set up a connection through Dreamweaver to the same database. Thanks