Solved

Oracle Database ODBC for Windows Server 2003 x64

Posted on 2008-10-29
5
2,445 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

910 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

18 Experts available now in Live!

Get 1:1 Help Now