Solved

Oracle Database ODBC for Windows Server 2003 x64

Posted on 2008-10-29
5
2,480 Views
Last Modified: 2016-12-08
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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

734 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