Dimensions include: instantclient-basic-wi
First, because the program to be run is 32-bit, you need to download the corresponding 32-bit oracle odbc program if the number of digits does not match, the system structure Mismatch Error will be reported on the following web site selection and database version corresponding odbc http://www.oracle.com/technetwork/topics/winsoft-085727.html includes: instantclient-basic-wi
First, because the program to be run is 32-bit, you need to download the corresponding 32-bit oracle odbc Program
If the number of digits does not match, the system structure Mismatch Error is reported.
Select odbc for the database version at the following URLs
Http://www.oracle.com/technetwork/topics/winsoft-085727.html
Includes: instantclient-basic-win32-11.2.0.1.0.zip (51,458,190 bytes)
Instantclient-odbc-win32-11.2.0.1.0.zip (744,125 bytes)
Decompress the two files and place them in the same folder.
Run odbc_install.exe to install
Pay attention to one problem When configuring odbc sources.
Because the program is 32-bit32-bit odbc source should be configured
Running Program: C: \ Windows \ SysWOW64 \ odbcad32.exe
For 64-bit programs, configure the 64-bit odbc source at C: \ Windows \ System32 \ odbcad32.exe
Enter the following configurations based on the oracle tnsnames Configuration:
Tns Configuration:
--------------------
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
--------------------
Odbc Configuration
Access the database directly using orcl as dns in the program.
M_retcode = SQLConnect (m_hdbc,
(SQLCHAR *) m_szServerName, // orcl
SQL _cnt,
(SQLCHAR *) m_szUserName ,//***
SQL _cnt,
(SQLCHAR *) m_szPassWord ,//***
SQL _cnt );