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

"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 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
3 Please check the validity of your tnsnames.ora. Check that your service name actually does occur in the tnsnames.ora 4 ORA-12154 is also the result of missing parentheses in tnsnames.ora 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.
6 Some reading of Oracle Net8 documentation won't harm you.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Sat Apr 20 2002 - 19:15:02 CEST