Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Oracle Odbc

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Oracle Odbc
# 1  
Old 12-12-2002
Question Oracle Odbc
Hello all,

i like to install an application program that will interact with
the oracle database.
oracle has been installed in /export/home/oracle
does the new application has to be in the same directory and
if not which one do you recommend?

There is a drive like the ODBC in oracle to glue the database with
the application and how can i set up the settings?

any info/solusions will be appreciated.

many thanks,

rs
# 2  
Old 12-12-2002
What is the application you are using with Oracle? It should have it's own database connection setup. If it does not the two most popular choices would be ODBC or Net8 (aka SQLNet). Net8 is probably more efficient and more flexible but only works with an Oracle DB so if you need your app to talk to another brand of database you would probably have to go back to the slower ODBC.

Most applications that I am aware of do not need to be in the same directory as the Oracle database or even on the same box for that matter. If you know the application, someone may be able to give you more specifics or tips on how to get it done.
# 3  
Old 12-13-2002
THANK YOU
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Solaris

odbc libraries

Hi, this is my first experience with Solaris. For work, I must configured an applicacion (oracle EPM, this include Datadirect odbc drivers) in solaris. Additionally, we must connect to Sybase IQ Database (I installed odbc drivers to do this). The problem is, I can't get those two odbc... (1 Reply)
Discussion started by: dmedinacl
1 Replies

2. Shell Programming and Scripting

Connecting to Oracle by using ODBC on UNIX

Hi All, I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine. I dont have Oracle client installed on my AIX so i can't use SQLPLUS command. But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies

3. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

4. Windows & DOS: Issues & Discussions

Oracle 9i ODBC connection

I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
3 Replies

5. UNIX for Dummies Questions & Answers

ODBC on UNIX

I see several questions regarding setting up ODBC on UNIX machines but I don't see any replies. I always thought ODBC was only possible on Windows machines, but I've recently heard drivers do exist for ODBC on UNIX. Does anyone know any more details about this: How to set up ODBC on UNIX, web sites... (1 Reply)
Discussion started by: ggmar
1 Replies

6. UNIX for Dummies Questions & Answers

ODBC Version

how to find the version of ODBC and the database drivers in Unix box :eek: (0 Replies)
Discussion started by: raghunath_mv
0 Replies

7. Solaris

How to check Oracle odbc connectivity in solaris ?

Hi, I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server. Please guide me how to do it in solaris env. Aru (2 Replies)
Discussion started by: aarora_98
2 Replies

8. UNIX for Advanced & Expert Users

Aix 5.3 L Odbc

Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L (0 Replies)
Discussion started by: uhdesai
0 Replies
Login or Register to Ask a Question