googleid_108119
10 years agoOccasional Contributor
How will TestComplete script interface with MS access DB(32 bit app) in 64 bit OS?
Hi
I'm using TestExecute to run my test complete scripts at windows 2008 64 bit OS and facing issue while trying to interface with MS access DB.
Problem: It gives a vb script run time error: 'unspecified error' for code containing recordset opening of MS access DB. I picked up infected line of codes & tried testing the MS access DB connection seperately in DBconnection_chk..vbs file and found the error code : 8000405 "Data source name not found & no default driver specified"
Steps taken so far: I learnt that MS access is a 32 bit application and tried to run DBconnection_chk.vbs file with c:\windows\syswow64\cscript.exe It worked and connection established.
Problem remains: The DB interface is a part of TestComplete script(.svb file) not the seperate code altogether in any vbs file. So I need to run the TestComplete script which is still giving same error. How would I configure TestExecute to run effectively in 64 bit OS while interfacing with MS access DB?
Please help.
Thanks
Sushil