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]

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" <gi*******@spammersuntied.com> wrote in message
news:HYsOc.2599$FW1.2307@lakeread06...

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]

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_***********@hotmail.com> wrote in message
news:zI***************@news.uswest.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" <gi*******@spammersuntied.com> wrote in message
news:HYsOc.2599$FW1.2307@lakeread06...

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]

"GitarJake" <gi*******@spammersuntied.com> wrote in
news:xCwOc.2697$FW1.45@lakeread06:

Hi Chris,

CONNECTIONSTRING = "Driver={Microsoft 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\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.
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