Nevermind. I missed the part where sqlplus was working on all three machines. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joel.Patterson@xxxxxxxxxxx Sent: Wednesday, July 11, 2007 8:39 AM To: smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: VB Access to Oracle Database (or make same as working copy). Like perhaps NTS authentication. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: Patterson, Joel Sent: Wednesday, July 11, 2007 8:38 AM To: 'smishra_97@xxxxxxxxx'; oracle-l@xxxxxxxxxxxxx Subject: RE: VB Access to Oracle Database Maybe you installed the other two differently. Check if there is a sqlnet.ora file present. Comment out or rename if so, and see. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra Sent: Tuesday, July 10, 2007 6:46 PM To: oracle-l@xxxxxxxxxxxxx Subject: VB Access to Oracle Database I had a weird situation where I had 3 PC and Oracle 10g Client is installed on them. I had installed one of the VB application on all three connecting to Oracle 10g DB. One PC is able to read the Service correctly and connect to the database while others are not THere is only One Oracle Home on them Sqlplus work fine in connecting to the Database and So TNS Service or alias are correct I tried to trace parameter in sqlnet.ora but found that only Sqlplus connection is only creating Trace file while there is no trace file created with VB Access which look like that it is not reading the Tnsnames. No Oracle errors except database does not exist I had also added TNS_ADMIN in environment pointing to OH/network/admin Any other suggestion TIA Sanjay ________________________________ Food fight? <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTE wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396545367> Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A. <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTE wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396545367>