How to download Microsoft ODBC drivers for Oracle on Windows 7 machine

Hi Aggarwal,

Thank you for posting your query in Microsoft community!

I understand that you want to create a odbc connection using microsoft odbc drivers for oracle. I will try to help you with this issue.

1. Which version of oracle are you using?
2. Which version of ODBC are you referring to?

Refer this link for drivers:

http://www.oracle.com/technology/software/tech/windows/odbc/index.html

ODBC--Open Database Connectivity Overview

http://support.microsoft.com/kb/110093

INFO: How to Install ODBC Components and Drivers

http://support.microsoft.com/kb/313008

Please post back if you are still experiencing the issue. I will be glad to provide you with the additional options available that you can utilize to get the issue resolved.

We look forward to hearing back from you.

Does anyone know if there is a way to make the "Microsoft ODBC for Oracle" driver (version 6.01.7601.17514) pull in Arabic characters?  The Arabic characters look correct in Toad but when I pull it into Excel, they just come up as questions marks "?".

=Æ=

I created the Microsoft ODBC drivers for Oracle this way,  

1. Find the table in MS Access not in Oracle (make sure all the column names and table names are Upper Case)
2. Right click > Export > ODBC Databases
3. Click OK
4. Click on the "Machine Data Source" tab
5. Click the New button
6. Click the radio button "User Data Sources"
7. Click the "Next >" button
8. Scroll down until you see the "Microsoft ODBC for Oracle" driver
9. Select it and click the "Next >" button
10. Add all the credentials and this will create driver and add it your Data Sources going forward

Hi AlvinEe

Excel gets the data just fine, but it is using the wrong encoding to interpret it, hence the "?". Try googling how to set your encoding in Excel to display Arabic characters.