Re: VB6 and Oracle Objects for OLE problem (TNS could not resolve)

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0204200915.62973132_at_posting.google.com...
> "Johnny Rollerfeet" <jr_at_rollerfeet.com> wrote in message
 news:<Dn7w8.17024$R33.774441_at_typhoon.austin.rr.com>...
> > I have an application in VB6 that uses Oracle Objects for OLE to access
 a
> > database. From my development machine, everything works fine. I can
> > connect to the database with the Net Configuration test and the
 application.
> > However, on my production server, the application cannot connect (TNS
 could
> > not resolve, etc.), but the Net Configuration test works fine.
> >
> > I've checked for duplicate tnsnames.ora, sqlnet.ora, ociw32.dll,
 ocip8.dll
> > and oradc.ocx files. I'm getting really frustrated.
> >
> > Anyone have a fresh idea?
>
>
> 1 Please search the groups archives before posting

I've searched through deja.com with a dozen different combinations of key words. Most of the posts I've found are fairly standard problems.

> 2 Please stop crossposting to half of the Internet. The majority of
> the groups you are posting to do not even exist and/or are not
> supported by all providers

All of the groups I am cross-posted to are supported by Road Runner which covers a good portion of users. Also, they all apply to my issues (Oracle, VB, OLE).
> 3 Please check the validity of your tnsnames.ora. Check that your
> service name actually does occur in the tnsnames.ora

Again, Net8 Configuration Assistant created/defined and tested the instance just fine. It;s only the VB application that can't seem to find it through TNS. I've never come across a case where the Config Assist (or previously with Easy Config) test works, but applications can't hit the db (barring duplicate TNSNames or wrong environment variables.)

> 4 ORA-12154 is also the result of missing parentheses in tnsnames.ora

Does this affect only external applications? Does Net8 Configuration Assistant misplace a parentheses always (in certain versions? if so, which versions)? Where is this documented?

> 5 On the server you can set the environment variable or registry
> variable ORACLE_SID to the SID of your instance, and you won't even
> need an instance name.

I'll try this. Where is this documented?

> 6 Some reading of Oracle Net8 documentation won't harm you.

I've covered most of the Net8 documentation. This is probably my 100th install of Oracle, but I'm fairly new to OO4O. Received on Sun Apr 21 2002 - 12:17:00 CEST