By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,583 Members | 1,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,583 IT Pros & Developers. It's quick & easy.

Error message on ODBC Connection

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
"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.