You can't do that - the 'bit-ness' if I might put it that way must match. A 32 bit application requires a 32bit ODBC driver, a 64bit app requires a 64bit driver.
Thank you for accepting the OTN License Agreement; you may now download this software. See the for more information about Instant Client. The are at the foot of the page. Client-server version interoperability is detailed in.
For example, Oracle Call Interface 18.3 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.
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? Kak uznatj nomer podshipnika po diametru vala. 2) Which version of ODBC are you referring to? Refer this link for drivers: ODBC--Open Database Connectivity Overview INFO: How to Install ODBC Components and Drivers 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.
Abdul Raqeeb Kola Former Microsoft Senior Support Engineer/ Sr. 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 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.
You can't do that - the 'bit-ness' if I might put it that way must match. A 32 bit application requires a 32bit ODBC driver, a 64bit app requires a 64bit driver.
Thank you for accepting the OTN License Agreement; you may now download this software. See the for more information about Instant Client. The are at the foot of the page. Client-server version interoperability is detailed in.
For example, Oracle Call Interface 18.3 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.
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? Kak uznatj nomer podshipnika po diametru vala. 2) Which version of ODBC are you referring to? Refer this link for drivers: ODBC--Open Database Connectivity Overview INFO: How to Install ODBC Components and Drivers 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.
Abdul Raqeeb Kola Former Microsoft Senior Support Engineer/ Sr. 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 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.