Fwd: VB Access to Oracle Database

list

it may, or may not be a version issue, but it looks like the list did well in troubleshooting the problem.

Niall

• Forwarded message ---------- From: Sanjay Mishra <smishra_97_at_yahoo.com> Date: Jul 11, 2007 6:53 PM Subject: Re: VB Access to Oracle Database To: Niall Litchfield <niall.litchfield_at_gmail.com>

Niall

Thanks for the link. I used filemon and found that there is no call to Oracle 10g dll and so I decided to deinstall the Oracle client and reinstalled the Runtime client and it is working fine now.

Thanks
Sanjay

*Niall Litchfield <niall.litchfield_at_gmail.com>* wrote:

get hold of the file utilities at
http://www.microsoft.com/technet/sysinternals/default.mspx (used to be called filemon, but may not be now) and you'll be able to find out what files the app is actually using.

Is the .msi internally produced or externally. We've had a lot of issues in the past with our desktop teams (2 organisations) using a snapshotting utility to determine what files and registry settings to include in an msi. This included including parts of the Oracle client and hardwiring user specific details into the registry.

HTH Niall

On 7/11/07, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
>
> Niall
>
> Yes you are right as otherwise the error should be like ORA-12454 or like.
> It look like is not reading the tnsnames.ora for Alias and so is the
> reason that there is no trace file generated.
>
> The strange point is that I used the same .msi file to install the
> application. Is it possible that user have some permission issue or
> reinstall Oracle Client
>
> Tx
> Sanjay
>
> *Niall Litchfield <niall.litchfield_at_gmail.com >* wrote:
>
> Hi Sanjay
>
> "database does not exist" is not an Oracle error. It looks like an
> application developers exception handling message to me which is masking the
> underlying error.
>
> It might well be worth running
>
> select username,service_name from v$session;
>
> once the vb app is successfully connected. That will tell you what service
> the machine is using.
>
> Niall
>
>
> On 7/10/07, Sanjay Mishra <smishra_97_at_yahoo.com > wrote:
> >
> > 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=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396545367>Enjoy some healthy debate
> > in the Yahoo! Answers Food & Drink Q&A.<http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396545367>
> >
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
> ------------------------------
> Ready for the edge of your seat? Check out tonight's top picks<http://us.rd.yahoo.com/evt=48220/*http://tv.yahoo.com/>on Yahoo! TV.
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


------------------------------
No need to miss a message. Get email on-the-go
<http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail%0A>
with Yahoo! Mail for Mobile. Get
started.<http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail%0A>



-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l