Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-03121 Unable to connect to Oracle via ODBC

Re: ORA-03121 Unable to connect to Oracle via ODBC

From: Mark Tomlinson <marktoml_at_gdi.net>
Date: Mon, 14 Sep 1998 19:10:01 GMT
Message-ID: <35ff6910.83725060@newshost.us.oracle.com>


Check your path setting, it MUST include the Oracle_home\bin directory...for the 32 Bit Oracle_Home... if you are using 16 bit then it would need to be the 16 bit oracle_home\bin directory.

lastly check the connection information that you gave the driver. Should be EXACTLY the same information that you gave SQL*Plus to connect with - no more - no less.
Example:

c> plus80 scott/tiger_at_mydb
SQL*Plus: Release 8.0.5.0.0 - Production on Mon Sep 14 15:8:19 1998

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.5.0.0 - Production

SQL> The my ODBC configuration would set up a DSN to use MYDB as the servername/SQL*Net connectstring/SQL*Net alias (whatever the specific driver terms this). Received on Mon Sep 14 1998 - 14:10:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US