After I prepared my new Windows 7 Enterprise x64 workstation with a bunch of 64-bit Oracle software, I also needed connectivity to Oracle from various 32-bit software. So, I downloaded and installed the latest and greatest 32-bit Oracle11g instant client (11.2.0.2.0) from OTN with all the goodies, including ODBC driver that I need for troubleshooting support issues of our MS Access 2003/2007/2010 users.
After I prepared my new Windows 7 Enterprise x64 workstation with a bunch of 64-bit Oracle software, I also needed connectivity to Oracle from various 32-bit software. So, I downloaded and installed the latest and greatest 32-bit Oracle11g instant client (11.2.0.2.0) from OTN with all the goodies, including ODBC driver that I need for. I installed Windows 7 Ultimate on a PC and I am trying to set up the ODBC drivers to use with Crystal Reports. I ran CR on my XP machine and have the ODBC settings EXACTLY the same on both PCs. When I click 'Apply & Test Connection' in the ODBC Driver Setup window, it gives me the following. I've been struggling to re-set up my ODBC for Oracle connection. My new laptop is Windows 10 pro, 64-bit. I'm running Access 2016. I've been tinkering with the properties based on googling around. Below is a common solution provided, but it does not work.
Odbc Error 193 Windows 7 32-bit
I opened 32-bit ODBC administrator (WindowsSysWOW64odbcad32.exe) and when I tried to add System DSN with instanclient 11.2 driver I was stopped with the error:
The setup routines for the Oracle in instantclient_11_2 ODBC driver could not be loaded due to system error code 14001.
as shown below :
Odbc File Location Windows 7
followed by instruction to check the Event log:
Stata is a complete, integrated statistical software package that provides everything you need for data analysis, data management, and graphics. Stata is not sold in pieces, which means you get everything you need in one package. Detailed list of the features that came out with the release of Stata 10, including the Graph Editor, multilevel mixed models, exact statistics, power analysis, endogenous variables, multivariate methods, dynamic panel data, choice models, survey and correlated data, updated GUI, time/date variables, saved results, and much more. If you are using Stata 10, and you have a direct Internet connection, type update query in Stata, and Stata will tell you if there are updates and what to do next. See R update in the Stata Base Reference Manual for more information. If you do not have access to the Internet from within Stata, see below. Stata 10 software. Stata makes it easy to generate publication-quality, distinctly styled graphs. You can point and click to create a custom graph. Or you can write scripts to produce hundreds or thousands of graphs in a reproducible manner. Export graphs to EPS or TIFF for publication, to PNG or SVG for the web, or to PDF for viewing. The Stata News—a periodic publication containing articles on using Stata and tips on using the software, announcements of new releases and updates, feature highlights, and other announcements of interest to interest to Stata users—is sent to all Stata users and those who request information about Stata from us. Yes, please send me the News.
Odbc 32 Windows 7
and so I did…
After I prepared my new Windows 7 Enterprise x64 workstation with a bunch of 64-bit Oracle software, I also needed connectivity to Oracle from various 32-bit software. So, I downloaded and installed the latest and greatest 32-bit Oracle11g instant client (11.2.0.2.0) from OTN with all the goodies, including ODBC driver that I need for. I installed Windows 7 Ultimate on a PC and I am trying to set up the ODBC drivers to use with Crystal Reports. I ran CR on my XP machine and have the ODBC settings EXACTLY the same on both PCs. When I click 'Apply & Test Connection' in the ODBC Driver Setup window, it gives me the following. I've been struggling to re-set up my ODBC for Oracle connection. My new laptop is Windows 10 pro, 64-bit. I'm running Access 2016. I've been tinkering with the properties based on googling around. Below is a common solution provided, but it does not work.
Odbc Error 193 Windows 7 32-bit
I opened 32-bit ODBC administrator (WindowsSysWOW64odbcad32.exe) and when I tried to add System DSN with instanclient 11.2 driver I was stopped with the error:
The setup routines for the Oracle in instantclient_11_2 ODBC driver could not be loaded due to system error code 14001.
as shown below :
Odbc File Location Windows 7
followed by instruction to check the Event log:
Stata is a complete, integrated statistical software package that provides everything you need for data analysis, data management, and graphics. Stata is not sold in pieces, which means you get everything you need in one package. Detailed list of the features that came out with the release of Stata 10, including the Graph Editor, multilevel mixed models, exact statistics, power analysis, endogenous variables, multivariate methods, dynamic panel data, choice models, survey and correlated data, updated GUI, time/date variables, saved results, and much more. If you are using Stata 10, and you have a direct Internet connection, type update query in Stata, and Stata will tell you if there are updates and what to do next. See R update in the Stata Base Reference Manual for more information. If you do not have access to the Internet from within Stata, see below. Stata 10 software. Stata makes it easy to generate publication-quality, distinctly styled graphs. You can point and click to create a custom graph. Or you can write scripts to produce hundreds or thousands of graphs in a reproducible manner. Export graphs to EPS or TIFF for publication, to PNG or SVG for the web, or to PDF for viewing. The Stata News—a periodic publication containing articles on using Stata and tips on using the software, announcements of new releases and updates, feature highlights, and other announcements of interest to interest to Stata users—is sent to all Stata users and those who request information about Stata from us. Yes, please send me the News.
Odbc 32 Windows 7
and so I did…
The 'Microsoft.VC80.MFC' part of the error message in Event Log was saying that some C++ redistributable libraries were missing. With some trial and miss I found out that I need to install 32-bit Microsoft C++ 2005 SP1 Redistributable Package (x86) on my Windows 7 x64.
I downloaded 'Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)' from Microsoft Download Center:
Notice the match of version numbers of libraries as shown on the last two pictures (8.0.50727.762)!
Windows 7 Odbc 64
After I installed 32-bit C++ 2005 libraries on my Windows7 x64 workstation I was able to use 32-bit ODBC driver with my Instant client 11g installation.
