Click to See Complete Forum and Search --> : ADODB connection to MS Access database


Wand3r3r
03-04-2003, 05:19 PM
I am tyring to create a small web application for an inter office network. I am having trouble creating the connection to the database.

This is the code I use to setup my connection
<%
set cn = server.createobject(ADODB.Connection)
cn.open "DSN=dpa"
%>

When trying to open the connection (cn.open "dsn=dpa") I get the following error:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Disk or network error."

I've researched the error on micorsoft's website and found this response:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B251254

I've check all the environment variables. TMP and TEMP point to C:\WINNT\Temp. I've verrified the existance of the directories.

Do you know anything that will or may help?

Thank you,

Mike