ODBC Driver installation for Oracle Express on Windows 10 64bit

Can someone point me to instructions on downloading/installing ODBC drivers for Oracle Express version?
iBincAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Can you explain what you are wanting to do?

Are you looking to put ODBC drivers under the XE ORACLE_HOME? I'm not sure you can.

I would look at getting the Instant Client and use the ODBC drivers from there:
http://www.oracle.com/technetwork/database/windows/index-098976.html

You can review this previously asked question:
https://www.experts-exchange.com/questions/28991923/Oracle-XE-local-ODBC-connection-drivers.html
0
 
iBincAuthor Commented:
I downloaded and unzipped but don't see an installation... I'm trying to connect via a 3rd party application to simple oracle user.  (HR)
0
 
slightwv (䄆 Netminder) Commented:
Downloaded which one?

On the link above for the Instant client there is a link:
Oracle Instant Client ODBC Release Notes - Installation Guide

Takes you to here:
http://www.oracle.com/technetwork/database/features/oci/odbc-ic-releasenotes-094306.html
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
iBincAuthor Commented:
Those instructions are for unix only. Can't seem to find clear instructions anywhere for XE Oracle ODBC. When I downloaded and unzipped there is not setup for install.
0
 
iBincAuthor Commented:
instantclient-basic-windows.x64-12.2.0.1.0.zip  is the installation...
0
 
iBincAuthor Commented:
I think I need the oracle installer but I don't know where it is...??
0
 
slightwv (䄆 Netminder) Commented:
>>Those instructions are for unix only

Scroll down.  There are Windows instructions.

On Windows
The procedure to install Instant Client ODBC on Windows is:
 
Install the Instant Client Basic or Basic Light package, as described above.
Unzip the Instant Client ODBC package.
Execute odbc_install.exe from the Instant Client directory. If Instant Client is 11g or lower, start the command prompt with the Administrator privilege. To install with Japanese language support, execute the command 'odbc_install.exe JA'.
0
 
iBincAuthor Commented:
Problem is I've done that and there is no odbc_install.exe
0
 
slightwv (䄆 Netminder) Commented:
You need to download two files.

Looks like you only got the Basic file.  There is a separate ODBC file that goes with the Basic:

Basic Package - All files required to run OCI, OCCI, and JDBC-OCI applications
ODBC Package - Additional libraries for enabling ODBC applications (Updated 9/20/2017)

I should also point out that the Bit version you need must match the application not the Operating System.
0
 
iBincAuthor Commented:
I will be connecting to Wherescape Red
0
 
slightwv (䄆 Netminder) Commented:
>>I will be connecting to Wherescape Red

I don't know anything about that product.  If it is 32Bit, you'll need the 32Bit Oracle drivers.  If it is 64Bit, get the 64Bit drivers.

You will also need to make sure you use the correct ODBC Admin version when you create the DSN:
https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
0
 
iBincAuthor Commented:
I downloaded the basic package... where do you see ODBC Package?
0
 
iBincAuthor Commented:
ok I found it.. also found the XE drivers... didn't need to download it.
0
 
slightwv (䄆 Netminder) Commented:
Assuming you want the 64Bit drivers, go to the download page:
http://www.oracle.com/technetwork/topics/winx64soft-089540.html
Untitled.jpg
0
 
slightwv (䄆 Netminder) Commented:
>>ok I found it.. also found the XE drivers... didn't need to download it.

Feel free to post the XE piece and accept that as the solution.
0
 
iBincAuthor Commented:
You are correct... Wherescape is 32 bit and the only one available to me is 64bit... so possibly I did install the 64...
When I have time I will download and install the 32.
0
 
iBincAuthor Commented:
Didn't work. .... I'm not really clear on how to install and not sure how I did get the XE for 64bit on my machine. Following the instructions (bad as they are) did not work for 32bit anyway.
0
 
slightwv (䄆 Netminder) Commented:
I'm not sure what you are referring to nor what all you have done.

You never posted what you did for the "ODBC for XE" comment you made above.

What I would do is:
Install XE 11g 64Bit.
Then install the 12.2 32Bit Instant Client with ODBC in a different folder.

Keep the client and database software separate.
0
 
iBincAuthor Commented:
I see the XE ODBC Drive for 64 bit in the ODBC Datasource App... I do not see the 34 bit equivalent in the ODBC 32 Bit Datasource App. They are two separate apps.

I do not know how the XE 64 bit was created, I do know the instructions given to install are not working (for 32 bit for sure). I copied to a separate folder both the ODBC package and the 32 bit package (both unzipped) and tried running the ODBC Install executable (as administrator) but nothing happens. It does say to add the directory to the path, maybe that is the issue.
0
 
slightwv (䄆 Netminder) Commented:
Looks like XE comes with the ODBC drivers but as you've already mentioned, it is 64Bit.  I didn't know since it has been years since I messed with XE and never needed the ODBC drivers.

>>and tried running the ODBC Install executable (as administrator) but nothing happens.

Did you double-click it from File Explorer or run it from a CMD prompt?  Some of the Instant Client install programs have parameters you need to install so they need to be run from a CMD prompt.
0
 
iBincAuthor Commented:
See attachment error message I receive running from cmd.
error.png
0
 
slightwv (䄆 Netminder) Commented:
What did the CMD window show not the popup?
0
 
iBincAuthor Commented:
It did... showed the popup.

Anyway, what I did was uninstall, then I deleted the directory and rebooted.... then I downloaded both again to new directory and added the directory to the PATH then IT WORKED!!!! YAY!!!

The popup was still there but I ignored it.
0
 
slightwv (䄆 Netminder) Commented:
You shouldn't have had to add it to the PATH but as long as you have it working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.