I'm facing issues while connecting My Automation Tool (QTP/Auto It) with Oracle 11g on Win7(64bit). I am using the same connection string in sample java program to connect with Oralce11g and it was connected successfully.
I've tried several steps, however it fails.
1 Add User DSN, test connection successful.(User DSN name is oracle)
2 Write sript in QTP/AutoIt to connect oracle.
Here is my connect string and error.
Set objCon=CreateObject("ADODB.Connection")
strConn1 = "DSN=Oracle;Driver={Oracle in OraDb11g_home1};SERVER=****;UID=***;PWD=****;DBQ=****:1521/****;"
objCon.Open strConn1
Error:[Microsoft][ODBC Driver Manager] The Specified DSN contains an architecture mismatch between the Driver and Application. Please find the attached screen shot for the same.
************************************************************
strConn = "Provider=OraOLEDB.Oracle;Password=Password;Persist Security Info=True;User ID=UserName;Data Source=****;server=****"
Error: Provider cannot be found. It may not be properly installed.
Some one who can help will be greatly appreciated.