Unified Functional Testing Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to oracle 11.2 from UFT 12

Highlighted
flawedlogic
Occasional Advisor

Connecting to oracle 11.2 from UFT 12

Hi,

 

I am trying to connect to oracle 11.2 from UFT12 using instantclient. The instanclient driver works sometimes and other time it gives me this error - A dynamic link library (DLL) initialization routine failed. (Oracle in instantclient_11_2, C:\instantclient\SQORA32.dll).

 

I have made the necessary settings in the env variables - Path and TNS_Admin.

 

I also tried using the microsoft odbc for oracle which is present by default in - c:\Windows\SysWOW64\odbcad32.exe.

This gave me a run error which mentioned only - [Microsoft][ODBC driver for Oracle][Oracle]  Line (7): "cnDatabase.Open".

 

I am not sure what this error means.

 

Any help is deeply appreciated.

 

Regards,

Anoop

 

1 REPLY
PriyankaPatil
Acclaimed Contributor

Re: Connecting to oracle 11.2 from UFT 12

Hello There,

 

Has anyone found the solution for his problem?

I am facing this too.

 

However same code successfully gets execute through VBA but fails in UFT.

 

I reinstalled oracle driver many times but still it runs fine sometimes but fails after some executions.

//Add this to "OnDomLoad" event