Invalid attribute in connection string. Nuby needs HELP!

[GitarJake]

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

[Chris Leonard]

Re: Invalid attribute in connection string. Nuby needs HELP!

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@spam mersuntied.comw rote in message
news:HYsOc.2599 $FW1.2307@laker ead06...

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
>
>
>

[GitarJake]

Re: Invalid attribute in connection string. Nuby needs HELP!

Hi Chris,

CONNECTIONSTRIN G = "Driver={Micros oft 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@ hotmail.comwrot e in message
news:zIvOc.189$ Qc.3715@news.us west.net...

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@spam mersuntied.comw rote in message
news:HYsOc.2599 $FW1.2307@laker ead06...

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

>
>

[Teresa Redmond]

Re: Invalid attribute in connection string. Nuby needs HELP!

"GitarJake" <gitarjake@spam mersuntied.comw rote in
news:xCwOc.2697 $FW1.45@lakerea d06:

Hi Chris,
>
CONNECTIONSTRIN G = "Driver={Micros oft ODBC for
Oracle};Server= db.world;Uid=sa ;Pwd=;"

What you have to do here is open TNSNAMES.ORA, which is located in your
OracleHome directory (C:\ORA_MGMT\ne twork\admin\TNS NAMES.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.

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

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