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_at_lakeread05>
Hello all,
Date: Mon, 2 Aug 2004 14:53:49 -0400
Message-ID: <55wPc.9155$pT5.8366_at_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 - 20:53:49 CEST