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

I am very new to Oracle and I don't know where to go to fix this. Any
help?

Thanks,

Jake

You need to start by telling us what your connection string is! It would
also help to see the output of "lsnrctl status" on the Oracle server.

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

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

Hi Chris,

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?

Thanks for your time,

Jake


"Chris Leonard" <s_p_a_m_chris (AT) hotmail (DOT) com> wrote

"GitarJake" <gitarjake (AT) spammersuntied (DOT) com> wrote in
news:xCwOc.2697$FW1.45@lakeread06:

What you have to do here is open TNSNAMES.ORA, which is located in your
OracleHome directory (C:\ORA_MGMT\network\admin\TNSNAMES.ORA for instance),
and see what the Service_Name is for db.world. Like this:

db.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SomeName)
(SERVER = DEDICATED)
)
)

In the above case, SomeName is the Service_Name for db.world (called SID
above). So your string would have Server=SomeName; instead of what you
have above.

That's a command line operation to find out the status of the listener.
I'm afraid I'm too much of a newbie to say more than that without looking
it up, myself... I'm trying to look it up now but OTN just isn't
responding.

--
Teresa Redmond
Programmer Analyst III
Anteon Corporation
delete X to email