Oracleodbc32-bit program connects to a 64-bit Database

Source: Internet
Author: User
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 );

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.