Re: Error ORA-12154 with Oracle OLE DB driver

From: Reinhard Brandstaedter <reinhard.brandstaedter_at_ams-engineering.com>
Date: Tue, 04 May 2004 12:58:48 +0200
Message-ID: <c77t1a$1md$1@ulysses.news.tiscali.de>

s.kapitza wrote:
> check if the service_name in tnsnames matches the service_name in init.ora
> (and listner.ora if configured)

Well these names do match. Otherwise other connections wouldn't work too.

I'm trying to connect to the Database via ADO (or the application does) via foloowing ADO Connect String:
Provider=OraOLEDB.Oracle;Password=exchangeolx;Persist Security Info=True;User ID=exchangeolx;Data Source=V7_AMS;Extended Properties=""

tnsping V7_AMS for example works fine.

The funny thing is that I've got two applications using the same connection string. One of them works fine the other one doesn't, although the developers of the apps ensured me they are using the same method for the connection.
So could this be a Oracle Client/Server Problem?

kr,
Reinhard Received on Tue May 04 2004 - 05:58:48 CDT