Re: ODBC problem

Weeeeellll,

I've had an ODBC link working for months, so taking your advice, I just went and changed the Data Source Name from 'TEST' to 'TEST%6325625'. My Service Name remained untouched as TEST (which is the rather imaginitive ORACLE_SID I use for these things).

Guess what? The link failed.

Changed it back to plain ol' TEST -and the Link works again.

Bizarre. As I originally posted, *I* thought the Source Name looked like it should be free-form text (though the Description field underneath worried me), but it's not worked for me that way.

Regards
HJR

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


"TurkBear" <johng_at_mm.com> wrote in message
news:3a1419b5.97453320_at_super.news-ituk.to...


>

> The 'Data Source Name' is exactly that - it is what you want to call this

> connection information object so that you can refer to it later ... It is

> independent of the 'Service Name' which refers to the Oracle instance (

 actually


> the tnsnames.ora or Names server entry that refers to the instance to

 which you


> want to connect )...So

> The Data source Name can be 'The Oracle Warehouse' or 'FooBar' and they

 can both


> connect to the same Oracle instance---the first one is better, in my

 opinion,


> because it lets you know where its connecting---if you have many of these

 ( I


> have @ 30 ) you will need something to remind you what they are for....

>

>

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

>

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

>

>

>

> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----

> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!

> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----