Oracleodbc32-bit program connects to a 64-bit Database

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 );