Oracle 9i ODBC connection

 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions Oracle 9i ODBC connection
# 1  
Old 11-25-2004
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 can access the database via SQLPLUS on the client using the Oracle client SQL. I can also access through a telnet SQLPLUS session. When I attempt to access the database in ACCESS using ODBC, I receive an error message:

ODBC - call failed.
Microsoft ODBC driver for Oracle ORA 12514: TNS: listerner could not resolve SERVICE_NAME given in connect descriptor (#12514) Driver's SQLSetConnectAttr failed IM006 0 (Microsoft) (ODBC Driver Manager) Driver's SQLSetConnectAttr failed (#)

I realize that Listener.ora and Tnsnames.ora on the client work together. On the server, should I have something comparable?

Also, on other examples I have seen SID used to identify a service, the Oracle client configured as SERVICE_NAME = xxxx rather than SID.

After I can establish this ODBC connection, my ultimate goal is to use dfPower DBMS/Copy on my XP client to load Oracle tables on the server through an ODBC connection.
# 2  
Old 11-25-2004
www.oracle-base.com

Check out http://www.oracle-base.com (if you havent done so already). You have to sign on (for free) and there are some restrictions:
Quote:
1. Use of Web Site Information
You may download, view, copy and print documents and graphics incorporated in these documents (the "Documents") from the Site subject to the following: (a) the Documents may be used solely for personal, informational, non-commercial purposes; and (b) the Documents may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not otherwise use, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit or distribute any information from this Web site in whole or in part without the express authorization of Oracle.
but there's a change your answer is in there somewhere.

(Yes, I know: if I quoted the answer to your problem it would constitute 'fair use', but I havent got a login myself.)

Good Luck,

Rogier
# 3  
Old 11-30-2004
I would like to thank everyone who responded. It turned out to be an ODBC driver problem, once I loaded the correct driver, my ODBC connection worked.
# 4  
Old 04-15-2008
Lightbulb Connecting to UNIX server database through ODBC

Hi,

I got the same error as the one you have posted,I am trying to link the database from MS Access 2007 to Oracle database on Solaris server.I am new to this ODBC connection and have no clue.My ODBC versions are 2.575.1117.00.Please let me know if this needs an upgrade and where I can find the upgrades.Thanks in advance for your help.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Establish ODBC connection from Linux

Hi All, I want to establish a ODBC connection to a database from linux and query the tables of a database. Please let me know how I can achieve this. Thanks and Regards Nagaraja Akkivalli. (0 Replies)
Discussion started by: Nagaraja Akkiva
0 Replies

2. Shell Programming and Scripting

Cron job fails with [DataDirect][ODBC lib] Connection not open error

Hi, When run the script directly...it executes as expected. But when put it in crontab the job fails with this error: Connection not open 08003: Connection not open Unable to connect to the database... how come it is not able to connect when cron job fires?... Do I need to... (7 Replies)
Discussion started by: nuthakki
7 Replies

3. Programming

Help in pro*c for Oracle connection

hi, am making oracle connection through pro*c using the following command sample: exec sql connect username identified by password. but m getting the following errors frequently even though listener and db is running fine but some times code is working fine and not giving errors. ... (2 Replies)
Discussion started by: senkerth
2 Replies

4. Linux

Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

Hi , I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0 I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH, ODBCINI , ODBCSYSINI etc . Getting the error as Data source name not found, and no default driver specified ERROR: Could not SQLConnect ... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies

5. 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

6. 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

7. SCO

SCO ODBC connection to Vista?

Hi, I'm trying to make an odbc connection to a SCO db using Vista, but I'm having some troubles. In the past I have used Vision97 on either windows 98 and XP, but it will not install on Vista. Is there an alternative driver that I can use to make my connection? Any other workaround? Thanks, ... (1 Reply)
Discussion started by: knewknow
1 Replies

8. 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

9. UNIX for Advanced & Expert Users

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... (2 Replies)
Discussion started by: rsh
2 Replies
Login or Register to Ask a Question

Featured Tech Videos