Forum Discussion
On screen i use Data-driven loop, excel is still open. Pop up dialog with excel is open... etc.
Close Excel and the pop-up dialog before running your test and try again. IIRC, the Keyword operation version of the Excel DDT loop uses the ACE driver to Excel. In the past, I've had problems with that driver if the excel document is actually open when I try to run the tests.
- David918 years agoFrequent Contributor
Once this is done, and at another Data driven crash it. :/ Same error.
- tristaanogre8 years agoEsteemed Contributor
Are you opening up the same file in another DDT loop? One thing I'm NOT sure of is whether or not DDT driver loops in Keyword tests properly "close" once the loop is done. In Script code, I'd call a DDT.CloseDriver() method after every loop once I'm done with the file. This closes the connection to the file and frees up the driver. In Keyword tests, I can't find an analog to do so which means that it's possible that, within a single Keyword test, you can't use the same file twice. HKosova, do you know if DDT Excel drivers instantiated in a Keyword test using the Data Driven Loop operation "close" the connection when the loop is done?
- HKosova8 years agoSmartBear Alumni (Retired)
David91 wrote:
I had Windows 8, Office 2013, SQL2008R2 (TEST was succes)
Now i have Windows10, Office 2016 (64 bit), SQL2L16
TestComplete is a 32-bit application so it needs 32-bit database drivers. Try installing the 32-bit version of Office drivers from here and see it it helps:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
(Select AccessDatabaseEngine.exe, not AccessDatabaseEngine_X64.exe.)
tristaanogre wrote:
HKosova, do you know if DDT Excel drivers instantiated in a Keyword test using the Data Driven Loop operation "close" the connection when the loop is done?
I believe the connections are closed at the end of the keyword test, not the loop. It's also possible to force close a connection by using the Call Object Method operation:
Object: Fully-qualified variable name, such as KeywordTests.Test1.Variables.MyVar or TestProject1.Variables.MyVar
Method: Disconnect
Related Content
Recent Discussions
- 7 hours agod_gfleetwood92
- 9 hours agoFFCB