Forum Discussion

googleid_108119's avatar
googleid_108119
Occasional Contributor
10 years ago

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 ...
googleid_108119's avatar
googleid_108119
Occasional Contributor
10 years ago
Thanks Alex



Even I feel the installaion of 32 bit DRIVEr is must. 



But in other case how would I run/configure below LOC within testcomplete script file(.svb) from folder C:\Windows\SysWOW64\odbcad32.exe. It runs from vbs file. 




Set objConnection  = CreateObject("ADODB.Connection")


DB_CONNECTION_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\NIX Automation\Codebase\DB\DB.mdb;"


objConnection.Open DB_CONNECTION_STRING


Set objCOMPRecSet = CreateObject("ADODB.RecordSet")


objCOMPRecSet.Open "<QUERY>", objConnection