Re: ODBC problem

Quite possibly.

I found no useful documentation on setting up ODBC, and had to do it by grope and feel. As it were.

As I said: my method 'works' in the sense that if they are both the same entry, there's nothing to get mixed up. But as I also said, I realise this is not terribly scientific!

If you've a clear description of what should go where, lead on Macduff.

Regards
HJR

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


<jocave_at_my-deja.com> wrote in message news:8uv1qd$v19$1_at_nnrp1.deja.com...


> In article <3a11d3ef_at_news.iprimus.com.au>,

>   "Howard J. Rogers" <howardjr_at_www.com> wrote:

 [Snip]


> >

> > 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!

>


> I have numerous DSN's that are different than their service names and

> have never seen this problem.  Is it possible that you're mixing up

> DSN's and Service Names in your connect strings?

>


> >

> > Regards

> > HJR