Any ideas?
Microsoft JET Database Engine error '80004005'
Unspecified error
/includes/Opendb1.asp, line 5
<%
Dim objConn1
set objConn1=Server.CreateObje
objConn1.ConnectionString=
objConn1.open server.mappath("./Database
%>
I have checked the permisions and all seem ok with the DB folder.
Help
B
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Actually, it's:
objConn1.Open "ConnectionString"
So this would override the .ConnectionString property set before.
A valid connection string is:
strConn = "Provider=Microsoft.Jet.OL
Hence, either state,
objConn1.ConnectionString = strConn
objConn1.Open
or,
objConn1.Open strConn
I should have said this before I have just moved this website from one server to another it was all working on the other one.
But I have done as you both as you said.
<%
Dim objConn1, strconn
set objConn1=Server.CreateObje
'strConn = "Provider=Microsoft.Jet.OL
strConn = "Provider=Microsoft.Jet.OL
objConn1.ConnectionTimeout
objConn1.CommandTimeout = 10
objConn1.Mode = 3 'adModeReadWrite
objConn1.ConnectionString = strConn
objConn1.Open
%>
I have also put it in the page and not in a include.
Have you any other thoughts?
Try for fun:
strDataPath = "D:\IIS Data\products\Database\DB.
set objConnection=Server.Creat
strConnectString = "Provider=Microsoft.Jet.OL
+ " Data Source= " & strDataPath & ";"_
+ " Mode=Share Deny None;User Id=admin;PASSWORD=;"
objConnection.ConnectionTi
objConnection.CommandTimeo
objConnection.Mode = 3 'adModeReadWrite
if objConnection.state = 0 then
objConnection.Open strConnectString
end if
Also, have verified that the IUSR account has read/write permissions to the D:\IIS Data\products\Database\dir
Fritz the Blank
Here is the mother of all '80004005' errors troubleshooting list:
http://support.microsoft.c
Fritz the Blank
Make sure there is a TMP or TEMP environment variable.
PRB: Error Message "Unspecified Error Was Not Handled" When You Use Visual InterDev to Debug ASP Page
http://support.microsoft.c
PRB: "Disk or Network Error" or "Unspecified Error" Returned when Using Jet
http://support.microsoft.c
Anthony
PRB: "Disk or Network Error" or "Unspecified Error" Returned when Using Jet
http://support.microsoft.c
Pointed me in the right direction. I reapplied the permissions on the C:\winnt\temp directory and all was fixed. Ya...
Thanks
Business Accounts
Answer for Membership
by: fritz_the_blankPosted on 2002-09-02 at 12:33:04ID: 7256987
This is what I use:
strDataPath = server.MapPath("accessdata
set objConnection=Server.Creat
strConnectString = "Provider=Microsoft.Jet.OL
+ " Data Source= " & strDataPath & ";"_
+ " Mode=Share Deny None;User Id=admin;PASSWORD=;"
objConnection.ConnectionTi
objConnection.CommandTimeo
objConnection.Mode = 3 'adModeReadWrite
if objConnection.state = 0 then
objConnection.Open strConnectString
end if
A few things to check:
Are you using an include file to hold your connection script? If so, try the page without using includes first, i.e. paste the code into the page proper. That will remove one variable.
Are you certain that the IUSR account has Read/Write permissions to the directory that holds the database?
Are you certain that the database is not open in Access? Sometimes if you have a table open in design view, you can run into grief.
Instead of using MapPath, try putting the complete string in for the path. If that works, we can adjust your syntax there, i.e. server.mappath("../Databas
Fritz the Blank