Forum Discussion

sunil_Rathore's avatar
sunil_Rathore
Occasional Contributor
9 years ago

An Attempt to work with Closed Driver in TC11.31

Hi,  I am using Tc11.31 and I have a project that uses DDT.ExcelDriver. I use DDT ExcelDriver with While loop. after some time I got JScript runtime error "An attempt to work with a closed driver".p...
  • tristaanogre's avatar
    tristaanogre
    9 years ago
    There is a maximum number of connections that the Microsoft Jet database engine (the engine behind the scenes of the DDT objects) can have open at a time. If you're while loop is opening connections each time through the loop, you're probably maxing out the connections. Make sure that, when you're done with the data in the driver, you call the DDT.CloseDriver(<drivername>) method to close the connection.
djadhav's avatar
djadhav
Regular Contributor

Even though I don't know what the exact problem is, here is a workaround. Keep the excel sheet opened in Microsoft Excel before you run your script.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago
There is a maximum number of connections that the Microsoft Jet database engine (the engine behind the scenes of the DDT objects) can have open at a time. If you're while loop is opening connections each time through the loop, you're probably maxing out the connections. Make sure that, when you're done with the data in the driver, you call the DDT.CloseDriver(<drivername>) method to close the connection.