Re: Error message on ODBC Connection

Your DSN configuration should be like this.  

 database name: MY_DBNAME
 description: whatever...

 user:          MY_USER 
 server:        MY_PASS

Try this first on command line,

 sqlplus MY_USER/MY_PASS_at_MY_DBNAME

If you get any error,
Find out right username(MY_USER), password(MY_PASS) and DBname(MY_DBNAME). and Set up tnsnames.ora correctly.  

Good Luck!

"GitarJake" <gitarjake_at_spammersuntied.com> wrote in message news:<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 Tue Aug 03 2004 - 07:16:01 CEST