Re: Create database link problem

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>TurkBear wrote:
>>
>> Hi,
>> I must be missing something:
>>
>> I create a database link ( say create database link foo connect to username
>> identified by userpass using 'fooalias' ) - fooalias is an entry in my
>> tnsnames.ora file and it works with a connect statement ( like connect
>> username_at_fooalias) and it also works fine with all my tools and apps, however
>> when try something like
>> select field1 from remotetable_at_foo
>> I get a TNS error, 'cannot resolve service name' ---
>>
>> The username has Create Session rights on the remote DB...what am I missing ?
>>
>> Thanks,
>> John Greco
>> MnDOT HR Office
>>
>> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
>> http://www.newsfeeds.com The Largest Usenet Servers in the World!
>> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
>
>it has to be in your tnsnames on the server not on the client, if thats
>of any use
>
>Cheers
>C
Thanks Connor, I'll check with that server's admin folks to see if they have set it up that way...

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Aug 24 1999 - 19:55:53 CEST