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.
LVL 1
jjozAsked:
Who is Participating?
 
mikainzConnect With a Mentor Commented:
Without Oracle Client you cannot make a ODBC connection to a Oracle DB.
But you do not need to install all components, look into the user defined setup.

Or you take a look at the Oracle Database Instant Client, see http://www.oracle.com/technology/tech/oci/instantclient/index.html
but I'm not sure wheter the Instant Client offers ODBC on x64 systems.
hth
 
0
 
mikainzConnect With a Mentor Commented:
Check out this Oracle Page for the Instant Client with x64
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winx64soft.html
 
0
 
jjozAuthor Commented:

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.
0
 
jjozAuthor Commented:
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
0
 
jjozAuthor Commented:
working solution for now.
0
All Courses

From novice to tech pro — start learning today.