Re: Problem connecting to database with Oracle Discoverer 4

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 06 Sep 2006 09:37:06 +0200
Message-ID: <edltha$q7v$4_at_news2.zwoll1.ov.home.nl>

antonyliu2002_at_yahoo.com schreef:
> Frank van Bortel wrote:

>> antonyliu2002_at_yahoo.com schreef:
>>
>>> http://static.flickr.com/76/228299512_75fca56471_o.gif
[Quoted] >> A simple "the error is TNS-12154 - listener could not resolve service
>> name" would have been more efficient...
>>
>>> I searched a little and modified the SQLNET.ORA and TNSNAMES.ORA under
>>> C:\orant\NET80\ADMIN as follows, but I am still getting the same error.
>> Why? The error is by the listener - that's on the database server
>> Probably, your entry in tnsnames.ora should be:
>>
>>      (CONNECT_DATA = (SERVICE_NAME = MyDBName.Mydomain.edu)
>>
>> If you do not know (it has been discussed before!), try
>>
>>      (CONNECT_DATA = (SID = MyDBName)
>>
>> --
>> Regards,
>> Frank van Bortel
>>

>
> Hi, Frank,
>
> Thanks a lot. I tried what you said, but I am still getting the same
> error. I've tried both
>
> (CONNECT_DATA = (SERVICE_NAME = MyDBName.Mydomain.edu)
>
> and
> (CONNECT_DATA = (SID = MyDBName)
>
> Neither worked.
>
> I am using the same connection string I used in my web application like
> below:
>
> DSN=MyDBName;UID=myUserID;PWD=myPassword; DRIVER={Microsoft ODBC for
> Oracle}; SERVER=199.220.3.6;
>
> Is this correct?
>
No, no, no - I'm referring to your Oracle network files; tnsnames.ora on your client in this case - I know nothing about a DSN.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Sep 06 2006 - 09:37:06 CEST