Re: ODBC problem

If you are using the Oracle ODBC driver to set up the connection in Control Panel - Administrative Tools - Data Sources, then the rule I've come up with is that you fill in the three key fields as follows:

Data Source Name - set it to be the Instance name to which you are trying to connect
Description - Anything that makes you happy Service Name - set it to be the instance name to which you are trying to connect

In short, the key thing I find is to make sure the Data Source Name and the Service Name are exactly the same thing, and that thing should be the tnsnames entry for the database. When I was setting this up first time, if I set those two things to be whatever succeeded as a tnsping address, no problems.

I originally made the mistake of thinking that 'Data Source Name' sounds like a chance to have a free text description of the thing (and the layout of the window kind of suggested it wasn't as important as the Service Name, too) -but it always fails for me unless the two match.

Not terribly scientific, but it works for me!

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"David Fitzjarrell" <oratune_at_aol.com> wrote in message
news:8ushhg$tgt$1_at_nnrp1.deja.com...


> In our last gripping episode "gun" <kimpin_at_pl.jaring.my> wrote:

> > I am using oracle 8.1.6 enterprise edition for windows 2000

 professional.


> > The connection to the database was successful using sql plus. I could

 create


> > table and add values into it.

> >

> > But when i need to connect to the ODBC, the problem occur. I have beed

> > checked out quite a number of site which provide the ODBC connection

> > problem. But I still couldn't get the ODBC connection part done.

> >

> > username=scott

> > password=tiger

> > service name=tcpexample

> >

> > although i change the login info to sytem/manager, but it still

 couldn't


> > work.

> >

> > I really hope that someone could help me on this.

> >

> > Thanks in advance.

> >

> > gun

> >

> >

>

> What error or errors are you getting?  It would help to know this

> information.

>

> --

> David Fitzjarrell

> Oracle Certified DBA

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.