Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
ODBC Driver for Windows 7 - 64 bit
Hi All,
I am having problems with using the Microsoft ODBC for Oracle Driver in Windows 7 - 64bit system. I am using the following code in my VB script
Set myConnection = CreateObject("ADODB.Connection")
myConnection.Open "Driver={Microsoft ODBC for Oracle};" & "Server=xxxxxx;" & "Uid=xxxxx;" & "Pwd=xxxxx"
Set myRecord = CreateObject("ADODB.recordset")
Sql = "Select * from employees where id= '01234'"
myRecord.Open Sql, myConnection
For Each r In myRecord.Fields
MsgBox r.Name
Next
I get the following error message: "The Oracle (tm) client and networking components are not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation, You will be unable to use this driver until these components have been installed"
"[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
Can you help me out on which version of Oracle client i need to install and what other settings I need to do on my Windows 7 system after the client installation.
Best Answer
-
HI All,
The above issue has been resolved. Since QTP is a 32 bit Application, we might need to use the 32 bit ODBC Data Source Administrator for creating the Oracle DNS. By default the control panel shows the 64 bit ODBC Data Source Administrator. Hence we need to use the “C:\Windows\SysWOW64\odbcad32.exe” from the Start-Run menu and open the 32 bit ODBC connection to create a Oracle DSN and then use that in the VBScript
Answers
-
I tried installing "instantclient-basic-windows.x64-11.2.0.4.0" and "instantclient-odbc-windows.x64-11.2.0.4.0" both. I ran the odbc_install.exe in command prompt as administrator and got the message "Oracle ODBC Driver is installed successfully."
I also set the environment Variable "Path" as "C:\instantclient_11_2".
But when tried to use the above VBScript to connect to the Oracle DB, i get the same error message. I am really stuck with this for past two days.
-
HI All,
The above issue has been resolved. Since QTP is a 32 bit Application, we might need to use the 32 bit ODBC Data Source Administrator for creating the Oracle DNS. By default the control panel shows the 64 bit ODBC Data Source Administrator. Hence we need to use the “C:\Windows\SysWOW64\odbcad32.exe” from the Start-Run menu and open the 32 bit ODBC connection to create a Oracle DSN and then use that in the VBScript