Solved

ODBC Drivers error 80004005

Posted on 2001-07-11
19
303 Views
Last Modified: 2008-02-01
I am connecting to an Access database on a Novell 5.X server (using a mapped drive) from an NT Workstation running IIS4 via an ASP page.  I get the following error when running the ASP page;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Out of Ms-DOS File handles.

When I move the Access database to the local drive everything works correctly and I don't get the error.  What can I do to get it to work correctly from the Novell server?

Thanks for your help,

John
0
Comment
Question by:JReynolds
  • 6
  • 5
  • 4
  • +1
19 Comments
 

Expert Comment

by:Icecube
ID: 6272916
do you have read/write access there ?
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6272989
You are leaving your recordsets and connection strinngs open in your scripts, ensure you use Close on your conn and rs.

conn.Close
rs.Close
0
 
LVL 10

Expert Comment

by:makerp
ID: 6272993
i dont think you can use mapped drives with access and ADO. anyway the performace will be terrible. if your using access make sure its on the same machine as the web server.
0
 
LVL 1

Author Comment

by:JReynolds
ID: 6273019
Yes, and the power is plugged in and the machine is turned on :-)  The database can be opened using MS Access on the NT Workstation from the network drive.  The tables from a local database can not be linked to the database on the network drive though.
0
 
LVL 10

Expert Comment

by:makerp
ID: 6273031
you may be able to open the database in access, but that means nothing, in ASP you are not accesing it via MS Access front end but rather a driver and ODBC
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6273033
You can access mapped drives with ADO, and yes, performance is degrating...
0
 

Accepted Solution

by:
Icecube earned 100 total points
ID: 6273055
This behavior occurs when password synchronization is enabled for the IIS 4.0
application. For IIS 5.0, password synchronization is called "Allow IIS to
control password."
 
When you connect to an Access database or that Access database is linked to
Access tables across the network, this problem can be caused by a combination of
password synchronization being enabled and a bug in the Odbcjt32.dll version
3.51.1029 (Microsoft Data Access Components 1.5). That particular problem has
been fixed in MDAC 2.0 and later.
 
Disable password synchronization for the Internet Information Server 4.0
application. For IIS 5.0, do not allow IIS to control the password. To do this,
perform the following steps:
0
 

Expert Comment

by:Icecube
ID: 6273058
See microsoft KB : Q189408
0
 
LVL 10

Expert Comment

by:makerp
ID: 6273060
okay so you can access access via mapped drives. i was under the impression that was not possible, i stand corrected.

>>Out of Ms-DOS File handles

it sound like either the OS has run out of filehandles or the user account that the db is being accessed under has a restriction on the number of filehandle and this has been reached. (bloddy Novell :|)
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 18

Expert Comment

by:mgfranz
ID: 6273186
Icecube, haven't we already discussed the issue of answering questions, especially if you do not know the true solution!  Your solution ~might~ be the answer, but ONLY if JReynolds is using MDAC 1.5, (highly unlikely since IIS4 loads 2.1).  From the "answer" you provided;

"...this problem can be caused by a combination of password synchronization being enabled and a bug in the Odbcjt32.dll version 3.51.1029 (Microsoft Data Access Components 1.5). That particular problem has been fixed in MDAC 2.0 and later."

Please do not lock questions by posting a "answer", especially a wrong one.
0
 
LVL 1

Author Comment

by:JReynolds
ID: 6273309
Yes, and the power is plugged in and the machine is turned on :-)  The database can be opened using MS Access on the NT Workstation from the network drive.  The tables from a local database can not be linked to the database on the network drive though.
0
 
LVL 1

Author Comment

by:JReynolds
ID: 6273402
Hey Icecube,
I am rejecting this answer for now to unlock the question.  I tried earlier to not allow IIS to control the password and that didn't work. It is using MDAC 1.5, I don't know why but, it is. I'm going to upgrade to MDAC 2.0 or greater.  If it works I'll select your answer.

John
0
 
LVL 10

Expert Comment

by:makerp
ID: 6273432
go to M$ and download MDAC 2.6 and JET 4.0, it has imrpoved my performace and reliablity orders
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6273455
I find it hard to believe that you have MDAC 1.5 installed on a NT 4 Workstation running IIS4...  What service pack are you using?
0
 
LVL 1

Author Comment

by:JReynolds
ID: 6273474
Hey Icecube,
I am rejecting this answer for now to unlock the question.  I tried earlier to not allow IIS to control the password and that didn't work. It is using MDAC 1.5, I don't know why but, it is. I'm going to upgrade to MDAC 2.0 or greater.  If it works I'll select your answer.

John
0
 
LVL 1

Author Comment

by:JReynolds
ID: 6273534
Hey Icecube,
You were right on!  We upgraded to MDAC 2.5 and it works.  I spoke with the guy who installed IIS 4.0 and he doesn't know why it wasn't upgraded to 2.1.

Thank you,
John
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 6273559
IIS 4 installs MDAC 2.1.

Perhaps you have no idea what you are running JR... Bu I guess a stab in the dark is better than no stab at all...
0
 
LVL 1

Author Comment

by:JReynolds
ID: 6276097
Sorry everyone but, I didn't install the OS, Service Pack, or IIS 4 so I don't know why it still had the MDAC 1.5.  The Workstation has Service Pack 6 on it so something must have replaced the newer files with old ones (must be a Microsoft thing).

Anyway, what a rough crowd of people you are, don't hold anything back just tell me like it is :-)..... Maybe I won't quit my day job.

Thanks again for all your help,
John
0
 

Expert Comment

by:Icecube
ID: 6276640
Your welcome !

If somebody thinks the same error can occur when all updates are there on the server, try to recreate that situation and give me some feedback on how to do that !
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
iis reverse proxy virtual directory 8 134
Summernote required 3 103
Scheduled IIS .Net2 AppPools recycle and SQL connection Hangs 33 93
Issues with Insert statement 12 16
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now