Solved

Oracle Database ODBC for Windows Server 2003 x64

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

860 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