Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: VB Access to Oracle Database

RE: VB Access to Oracle Database

From: Kerber, Andrew W. <>
Date: Wed, 11 Jul 2007 09:45:13 -0500
Message-ID: <>

If it is going through the 8i client I don't think it can connect to an 10g instance.  

-----Original Message-----
From: Sanjay Mishra [] Sent: Wednesday, July 11, 2007 9:43 AM
To: Kerber, Andrew W.; Subject: RE: VB Access to Oracle Database  


I will try this but if it is working fine on other PC, then it look strange. Anyway I found one interesting point that the PC where it is working has Oracle 8i and 9i Client installed and so It may be possibel that this application is specifically compile with other libraries. I will update if I found somethink that in next email.  



"Kerber, Andrew W." <> wrote:

        Once in the past I had an app default the tnsnames.ora to $TNS_ADMIN/sample/tnsnames.ora instead of $TNS_ADMIN/tnsnames.ora.          

        You might check and make sure its not trying to go to the sample tnsnames, perhaps by moving, renaming, or deleting it.          

	-----Original Message-----
[] On Behalf Of Sanjay Mishra
	Sent: Tuesday, July 10, 2007 5:46 PM
	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?
wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396545367> Enjoy some healthy debate

        in the Yahoo! Answers Food & Drink Q&A.
wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396545367>         

        NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.                  


Yahoo! oneSearch: Finally, mobile search that gives answers
earch?refer=1ONXIC> , not web links.

Received on Wed Jul 11 2007 - 09:45:13 CDT

Original text of this message