I am using the microsoft dBase driver in ODBC to access a .dbf file through ASP.
I am running NTserver with IIS.
It works great for a while and then after some recordset activity (not much either, say 15-20 collections of not much data) it comes back with this error.
Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
[Microsoft][ODBC dBase Driver] System resource exceeded.
I then need to reboot my server, to get things running again. Not good. :(
I have checked to make sure that I have closed off my connections after using them.
I have upgraded to MDAC 2.5. I have installed the most recent Borland Database Engine.
I believe it to be a connection pooling issue or such???? perhaps. If it is how do I go about fixing it.??
There was a previous question of this nature, but the answer involved a reinstall of the OS etc. That is not an option for me.
Could this be a known bug or something like that, with the dBase ODBC drivers??
I am in deep trouble here if I can't work out what is going on really fast.