RE: VB Access to Oracle Database
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: smishra_97@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Jul 2007 08:46:23 -0500
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
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>
------------------------------------------------------------------------------
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.
==============================================================================
Other related posts:
