Microsoft JET Database Engine error "80004005"

Hi all,

I have a problem opening an Excel file in ASP with OLEDB.

The opening can works for a lot of page calls but after an unspecified
duration, it not work at all and give me the error for all page calls :

Microsoft JET Database Engine error '80004005'
Erreur non sp=E9cifi=E9e
/ExcelAction.asp, line 137

The error is in French but I think the english version is "Unspecified
Error" (very intuitive message :) )

Here is the code :
set objConnExcel =3D server.CreateObject( "ADODB.Connection" )
objConnExcel.ConnectionString =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DD:\xlFile.xls;Extended Properties=3DExcel 8.0;Jet OLEDB:Engine
Type=3D35;HDR=3DNO;IMEX=3D1; "
objConnExcel.Open

It crash on "objConnExcel.Open"

I don't know where could be the problem.

Thanks for your help,

Ze Seb

Re: Microsoft JET Database Engine error "80004005"

tassne@netcourrier.com wrote:
> Hi all,
>
> I have a problem opening an Excel file in ASP with OLEDB.
>
> The opening can works for a lot of page calls but after an unspecified
> duration, it not work at all and give me the error for all page calls
> :
>
> Microsoft JET Database Engine error '80004005'
> Erreur non spécifiée
> /ExcelAction.asp, line 137
>
> The error is in French but I think the english version is "Unspecified
> Error" (very intuitive message :) )
>
> Here is the code :
> set objConnExcel = server.CreateObject( "ADODB.Connection" )
> objConnExcel.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=D:\xlFile.xls;Extended Properties=Excel 8.0;Jet OLEDB:Engine
> Type=35;HDR=NO;IMEX=1; "
> objConnExcel.Open
>
> It crash on "objConnExcel.Open"
>
> I don't know where could be the problem.
>
> Thanks for your help,
>
> Ze Seb
It could be you need to specify a different Jet EngineType - perhaps 40.
However, from the examples I've seen, EngineType does not even need to be
specified.
Are you specifying the correct version of Excel? See this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;2789 73

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Microsoft JET Database Engine error "80004005"

Hi,

It doesn't resolve the problem, I've tried other connection strings and
it seems that this is Jet which have a problem,

It gives me the same error for all these connection strings :
- "Provider=Microsoft.Jet.OLEDB.4.0"
- "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls"
- "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls;Extended
Properties=Excel 8.0;"
- "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls;Extended
Properties=Excel 9.0;Jet OLEDB:Engine Type=40;"
- "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls;Extended
Properties=Excel 10.0;Jet OLEDB:Engine Type=40"

Only a reboot of the server (relaunch IIS make nothing) resolve the
problem... But it is not a good solution. :)

So I think that there is a problem with jet... A lock or else that
cause this unspecified error. So is there a way to "reboot" Jet ?

Thanks for your quick reply,

Ze Seb

Re: Microsoft JET Database Engine error "80004005"

Try closing explicitely all opened connections as the end of each ASP pages.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


wrote in message
news:1133886548.848182.216670@g47g2000cwa.googlegroups.com.. .
> Hi,
>
> It doesn't resolve the problem, I've tried other connection strings and
> it seems that this is Jet which have a problem,
>
> It gives me the same error for all these connection strings :
> - "Provider=Microsoft.Jet.OLEDB.4.0"
> - "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls"
> - "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls;Extended
> Properties=Excel 8.0;"
> - "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls;Extended
> Properties=Excel 9.0;Jet OLEDB:Engine Type=40;"
> - "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\xlFile.xls;Extended
> Properties=Excel 10.0;Jet OLEDB:Engine Type=40"
>
> Only a reboot of the server (relaunch IIS make nothing) resolve the
> problem... But it is not a good solution. :)
>
> So I think that there is a problem with jet... A lock or else that
> cause this unspecified error. So is there a way to "reboot" Jet ?
>
> Thanks for your quick reply,
>
> Ze Seb
>

Re: Microsoft JET Database Engine error "80004005"

The problem is there is a lot of websites on our server and for
testing, it is not really easy...

There is no way to reinitialyze the Jet engine (close all opened
connection on it or else) ?

Thanks,

Ze Seb

Re: Microsoft JET Database Engine error "80004005"

tassne@netcourrier.com wrote:
> The problem is there is a lot of websites on our server and for
> testing, it is not really easy...
>
> There is no way to reinitialyze the Jet engine (close all opened
> connection on it or else) ?
>
No, there is no shortcut to this, besides restarting the inetserver process.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Microsoft JET Database Engine error "80004005"

The inetserver process is the IIS service ? If yes, it has is not
effect on the problem, for now, we have only found a hard reboot as a
solution... Which is not a solution...

Thanks,

Ze Seb

Re: Microsoft JET Database Engine error "80004005"

tassne@netcourrier.com wrote:
> The inetserver process is the IIS service ? If yes, it has is not
> effect on the problem, for now, we have only found a hard reboot as a
> solution... Which is not a solution...
>
I'm not convinced that closing connections will solve this issue for you.
Frankly, having never used ADO to deal with Excel files, I'm not sure what
the problem really is. You may need to get MS product support involved.
However, it will probably be cheaper to start by going through the code and
making sure all connections to the Excel files are closed and destroyed, and
seeing if that helps alleviate the symptoms.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Microsoft JET Database Engine error "80004005"

Ok, I will try it.

Thanks for your help,

Ze Seb