Re: Oracle 8i and ODBC

> 1. Can someone explain in simple English the difference between Data
 Source
> Name and Data Source Service Name and User ID in the Oracle8 ODBC
 driver set
> up?

The DSN is the name of the ODBC data source as listed in the ODBC administrator. It is arbitrary and can be anything you chose. It will be required by the application making the ODBC connection.

The service name is the Oracle TNS alias for the RDBMS you are connecting to. This can either be an entry in your local TNSNAMES.ORA file, or it can be one defined on the Oracle Names Server -- if you are using Oracle Names.

The userid is the default username that you wnt to ODBC driver to attempt the connection as. If you are going to use OS Authentication, you MUST leave this set to nothing. Otherwise, you may enter the database user name that you will normally be connecting as. This can be changed at the point the connection is being made if you wish to connect as a different user.

>
> For DSN I have tried the name of the EPM dataset and for service name
 I have
> tried "MyDatabase" and I have left UserID blank. When attempting to
 connect
> to the DB from the EPM (which uses ODBC) I get the following error
 message:
> ORA-12541: TNS: no listener.
>

Your database must have a listener running in order for you to conect. As a sanity check, be sure that you can connect from that same machine using an Oracle tools (such as SQL*Plus). If you are using Personal Oracle then you may need to start a listener.

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com http://www.deja.com/
Before you buy.