Hi All,
I have a solution for the oracle connection, if anyone is installed TestComplete tool in Windows7 64 bit OS
1> Install TestComplete tool in any drives, but make sure the path does not contain any Special characters(e.g "C:\Program Files (x86)\AutomatedQA\TestComplete")
2> Install Oracle10g 32 bit client on the same machine
3> To Create the DSN to connect Oracle DB open the 32 bit ODBC administrator
"C:\Windows\SysWOW64\odbcad32.exe"
4> Use following connection string to open the connection to Oracle DB
ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=Username;Password=pwd;Data Source=DSN_Name"