Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-03121 Unable to connect to Oracle via ODBC
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