Forum Discussion

raguaaa45's avatar
raguaaa45
New Contributor
7 years ago

ErrorMicrosoft JET Database EngineUnspecified error

I am facing this weird issue of "Error - Microsoft JET Database Engine Unspecified error" whenever am executing the scripts as a module.

 

Say for example am executing a module of 25 scripts,the 10th or 11th script fails with the error "Error
Microsoft JET Database Engine.Unspecified error"

 

However when i execute the scripts individually,it is working fine.

 

Am using MS office 2013

Am passing test data from the excel with the following syntax

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source = Testdata.xls;Persist Security Info=False;Extended Properties=Excel 8.0;"

 

1 Reply

Sort By
  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    7 years ago

    The Jet Database engine only allows a set number of open connections.  So, if during your test run you're exceeding those connections (and they aren't all to the same database or file, but in total), you might get this error.  Basically, once you've opened a connection, you need to make sure that, as soon as you've obtained the necessary data, you close the connection.  Using the DDT.ExcelDriver object, this is done by using the DDT.CloseDriver method.

     

    How are you actually opening your connection to the excel spreadsheets?  What does your code look like?