Error message on ODBC Connection

From: GitarJake <gitarjake_at_spammersuntied.com>
Date: Mon, 2 Aug 2004 14:53:49 -0400
Message-ID: <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 Received on Mon Aug 02 2004 - 13:53:49 CDT