Solved

Oracle Database ODBC for Windows Server 2003 x64

Posted on 2008-10-29
5
2,433 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:jjoz
  • 3
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
mikainz earned 500 total points
ID: 22838683
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
 
LVL 8

Assisted Solution

by:mikainz
mikainz earned 500 total points
ID: 22838691
Check out this Oracle Page for the Instant Client with x64
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winx64soft.html
 
0
 
LVL 1

Author Comment

by:jjoz
ID: 22846673

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
 
LVL 1

Author Comment

by:jjoz
ID: 22883930
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
 
LVL 1

Author Closing Comment

by:jjoz
ID: 31511560
working solution for now.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now