Re: VB Access to Oracle Database

  • From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Wed, 11 Jul 2007 11:41:40 -0500

Looks like I misread the earlier post,  Its working correctly on the machine
with the 9i and 8i clients on it.   In that case, it just about has to be
compiling against 9i on the working machine, since 8i client wont work with
the 10g database.  I believe only 9i will work on 8i, 9i, and 10g.

On 7/11/07, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:


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." <Andrew.Kerber@xxxxxxx>* 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-----
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sanjay Mishra
*Sent:* Tuesday, July 10, 2007 5: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


 some healthy debate
in the Yahoo! Answers Food & Drink 

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 
not web links.

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: