RE: VB Access to Oracle Database

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <Joel.Patterson@xxxxxxxxxxx>, <smishra_97@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Jul 2007 09:12:40 -0400

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> 

Other related posts: