Access db connection works on ws but not server 1

EchoAlertcom · Dec 22, 2003

Can anyone help with this please?

I am having trouble connecting to a db on our server. It works when I put the .asp page and db on my workstation.

I have checked NTFS Permissions, IIS Permissions, I have tried in different directories, I have tried using a DSN nothing works. Any suggestions?

The error is:

Code:

Microsoft JET Database Engine error '80004005' 
Unspecified error 
/wap/test5.asp, line 5

Code:

<html><head></head><body>
<%
set conn=Server.CreateObject(&quot;ADODB.Connection&quot;)
conn.Provider=&quot;Microsoft.Jet.OLEDB.4.0&quot;
conn.Open &quot;d:\web\wap\waptest.asp&quot;

set rs=Server.CreateObject(&quot;ADODB.recordset&quot;)
rs.Open &quot;Select * from TestTable&quot;, conn

for each x in rs.fields
   response.write(x.name)
   response.write(&quot; = &quot;)
   response.write(x.value) & &quot;<br>&quot;
next

rs.close
conn.close
%>
</body></html>

hithere · Dec 22, 2003

don't know if this is the cause but...may be worth checking out.

http://www.aspemporium.com/aspEmporium/help/helpsys.asp?PRB022

"Where's the Ka-Boom? There's supposed to be an Earth-shattering Ka-Boom!"
Marvin the Martian

GaryC123 · Dec 22, 2003

waptest.asp is the name of your database? And the path is correct?

http://www.intouchmedialtd.com

EchoAlertcom · Dec 23, 2003

I verified that the directory permissions allowed the IUSR account to create the ldb file buy opening the db in Access and seeing the ldb file appear.

Gary. Thanks for catching my typo. That actually happened when I was changing the specifics for posting here. the actual test file does have the correct filename and path.

Here is the message when I try to use a DSN:

Code:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Microsoft Access Driver] Disk or network error. 
/wap/test5.asp, line 12

Line 12 is:

Code:

conn.Open &quot;dsn_Wap_Test&quot;

Thanks for the help.

Sincerely,
Steve

GaryC123 · Dec 23, 2003

http://support.microsoft.com/defaul...port/kb/articles/Q251/2/54.asp&NoWebContent=1

http://www.intouchmedialtd.com

mopacfan · Dec 23, 2003

My guess is the oledb drivers themselves, have you verified that the latest version of MDAC is installed on the server? It's quite possible that the divers on the server are out of date. I've found this to be the case several times when developing for clients on my network and then installing the app on their server only to have it crap out.

Good Luck

EchoAlertcom · Dec 23, 2003

mopacfan -

That was it. I updated the MDAC to 2.8 and the issue went away.

Thank you.

Cheer,
Steve

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Access db connection works on ws but not server 1

EchoAlertcom

IS-IT--Management

hithere

Programmer

GaryC123

Programmer

EchoAlertcom

IS-IT--Management

GaryC123

Programmer

mopacfan

Programmer

EchoAlertcom

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor