469,643 Members | 1,341 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Error message on ODBC Connection

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
Jul 19 '05 #1
2 13400
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" <gi*******@spammersuntied.com> wrote in message news:<55wPc.9155$pT5.8366@lakeread05>...
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

Jul 19 '05 #2
"GitarJake" <gi*******@spammersuntied.com> wrote in message news:<55wPc.9155$pT5.8366@lakeread05>...
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


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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kenneth Foli Jørgensen | last post: by
3 posts views Thread by Giuseppe D'Elia | last post: by
2 posts views Thread by Chuck Ritzke | last post: by
2 posts views Thread by GitarJake | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.