RE: VB Access to Oracle Database

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: "Sanjay Mishra" <smishra_97@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 11 Jul 2007 09:45:13 -0500

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

 

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

 

Andrew

 

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.

 

Tx

Sanjay

"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

         

        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.
        
        
========================================================================
======

 

  

________________________________

Yahoo! oneSearch: Finally, mobile search that gives answers
<http://us.rd.yahoo.com/evt=48252/*http:/mobile.yahoo.com/mobileweb/ones
earch?refer=1ONXIC> , not web links. 

Other related posts: