Do you know what is wrong?

[juancarlosc]

Hi,

Can anyone tell me what is wrong with this connection, I am trying to connect to my acces database.The server is not in my computer, I already created a DSN connection called "survey", I am trying to use a DNS less connection but it doesn t work I keep getting these message:

"There was an error processing your request. Please contact an administrator from the contact page."

This is the code:
<%
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & "Dbq=http:\\www.iadb.org\ict4dev\asp\wsissurvey.mdb;" & "Uid=admin;" & "Pwd="
%>

Thank you very much
JC

[Roy Sinclair]

ODBC using DSN-Less connections would be totally unaware of how to handle a url like this one: http:\\www.iadb.org\ict4dev\asp\wsissurvey.mdb. It needs a direct file address based on the file system, not a url.

[glenngv]

And database should be not accessible via http request, or else anybody can download it if a user was able to guess the filename. See this thread (http://www.codingforums.com/showthread.php?t=33092#postmenu_171536) for the solution.