cancel
Showing results for 
Search instead for 
Did you mean: 

An Attempt to work with Closed Driver in TC11.31

SOLVED
sunil_Rathore
Occasional Contributor

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".please help to overcome this problem.....

 

1 ACCEPTED SOLUTION

Accepted Solutions
tristaanogre
Community Hero

Re: An Attempt to work with Closed Driver in TC11.31

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.

Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

View solution in original post

5 REPLIES 5
dmiscannon
Frequent Contributor

Re: An Attempt to work with Closed Driver in TC11.31

Please provide some more details. If you could copy the code that uses the DDT and While loop someone may be able to identify the issue.

djadhav
Regular Contributor

Re: An Attempt to work with Closed Driver in TC11.31

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
Community Hero

Re: An Attempt to work with Closed Driver in TC11.31

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.

Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available

View solution in original post

sanaumar
New Contributor

Re: An Attempt to work with Closed Driver in TC11.31

Hi, Excel was working absoultely fine with my scripts, but like 2 days ago i got the same Error, when i debug the issue i found that Excel is upgraded to 64 bit from 32 bit.

All my scripts are working absoultely fine with 32 bit Excel.

 

This is the Time Test Complete shopuld work on this and should give support for 64 bit Excel!

 

Best Regards!

ohakim
Senior Member

Re: An Attempt to work with Closed Driver in TC11.31

You need to update your excel data Access 

 

https://support.smartbear.com/testcomplete/docs/general-info/system-requirements.html#additional-req...

 

https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

 

 

followed the installation of the file   'AccessDatabaseEngine.exe'

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors