asked on

Oracle Database ODBC for Windows Server 2003 x64

Hi,

I'd like to have a connection to Oracle database (8.1.7 on Solaris) and at the moment I've got Atlassian Jira which needs to be connected to Oracle DB on my Win Server 2k3 x64.

the question is, do i have to install the Oracle Client 10g R2 10.204) x64 on that server so that i can have ODBC connectivity ?

it's quite big around 714 MB for the installation, is there any other alternative to make the connection possible without installing the Oracle Client ?

Thanks.

ASKER CERTIFIED SOLUTION

mikainz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mikainz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jjoz

ASKER

Hm.. i tried to install Oracle 11g (Version 11.1.0.6.0) it got error in Connecting to Oracle 8.1.7 :-|

I'll have to try with Oracle 10g version then.

jjoz

ASKER

At last i download the needed packages:

instantclient-basic-win-x86-64-10.2.0.3.0.zipinstantclient-sqlplus-win-x86-64-10.2.0.3.0.zipinstantclient-odbc-win-x86-64-10.2.0.3.0.zip --> somehow the download URL is pointing to the SDK instead of the ODBC !!!

i extract them all into one single folder and then i have to set the

PATH=<installdir>
TNS_ADMIN=<installdir>
SET NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 --> eventhough I'm in Australia.

then run odbc_install.exe

SQLPLUS is working fine from CommandPrompt

but from ODBC | System DSN, i couldn't see the Database service name because the text is somehow garbled ?

any idea guys ?

ODBC.jpg

jjoz

ASKER

working solution for now.