Hello all,

I am trying to test an ODBC connection to an Oracle dbf using the ODBC Data
Source Administrator. It's not working and I suspect I haven't configured
Oracle correctly. Below is the error message I am getting:

[DataDirect][ODBC Oracle Driver]Invalid attribute in connection string:
Description.[DataDirect][ODBC Oracle Driver][Oracle]ORA-12514: TNS:listener
could not resolve SERVICE_NAME given in connect descriptor

The connection string follows:

CONNECTIONSTRING = "Driver={Microsoft ODBC for
Oracle};Server=db.world;Uid=sa;Pwd=;"

I can't find "lsnrctl status" on my server. This is 9i, does that count?

I am very new to Oracle and I don't know where to go to fix this. Thanks
for your time,

Jake

Your DSN configuration should be like this.

database name: MY_DBNAME
description: whatever...
user: MY_USER
server: MY_PASS

Try this first on command line,

sqlplus MY_USER/MY_PASS@MY_DBNAME

If you get any error,
Find out right username(MY_USER), password(MY_PASS) and DBname(MY_DBNAME).
and Set up tnsnames.ora correctly.

Good Luck!


"GitarJake" <gitarjake (AT) spammersuntied (DOT) com> wrote

"GitarJake" <gitarjake (AT) spammersuntied (DOT) com> wrote

Ora-12514:
There is an entry called db.world in your tnsnames.ora on the system
running odbc. Following db.world's definition you will find a line
reading
service_name = <.....>

The listener thinks there is no database with an init.ora parameter
service_name = matching your tnsnames.ora entry.

If you don't have lsnrctl on the system serving the database (read
carefully, not necessarily the system running ODBC) this would point
to an installation problem.

Using lsnrctl status and optionally the init<sid>.ora for the database
you are trying to connect to,you should be able to troubleshoot your
problem.

Hth,

--
Sybrand Bakker
Senior Oracle DBA