Forum Stats

  • 3,816,048 Users
  • 2,259,134 Discussions
  • 7,893,369 Comments

Discussions

odbc dsn installation

elmousa68
elmousa68 Member Posts: 180 Blue Ribbon
edited Sep 19, 2014 12:01PM in ODBC

Dear all,

This might seem as a trivial question, but I have a machine with Windows XP SP3 installed. I want to connect to an Oracle database located on an intranet server through odbc. The Microsoft driver that is on the machine does not have a field to specify TSN service name. I came across documentation on the web (an Oracle document) which shows an Oracle DSN which contains a field for TSN service name and other parameters.

The question: Where do I get this driver, and how do I install it?

Tagged:

Answers

  • svenkatn-Oracle
    svenkatn-Oracle Member Posts: 74 Employee

    Hi,

    If you are trying to connect 11g database, please use the below link to download the Oracle Client 11.2.0.3

    https://updates.oracle.com/download/10404530.html

    If you want to install 32 bit driver, choose platform or language as "Microsoft Windows 32 bit",  download and install the file 3 of 6 - p10404530_112030_WINNT_3of6.zip

    If you want to install 64 bit driver,  choose platform or language as "Microsoft Winodws X64 (64-bit) "  download and install the file 4 of 7 - p10404530_112030_MSWIN-x86-64_4of7.zip

    Please set TNS_ADMIN to see the list of databases available in TSN.

    Thanks and regards

    Venkat

    Oracle Support

This discussion has been closed.