Re: VB Access to Oracle Database

Dennis
   
  I don't think I ma using ODBC as nothing is configured from ODBC perpective. 
The VB application is .msi compiled with Oracle libraries on the development 
side and I had executed the msi executable to install the application on all QA 
workstation.
   
  I will check with Development as if the VB application is compile with Oracle 
10g or any other version which may be giving this issue. As I found that PC 
where it is working has Oracle 8i/9i/10g client installed.
   
  Tx
  Sanjay

Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:
    Sanjay,
   
  I'm no VB expert, just a DBA that has had to deal with VB developers. 
Usually, I say that if SQL*Plus works correctly, then SQL*Net is correctly 
configured so the problem must be in VB or the Microsoft configuration. 
      All the things you mention that you tried simply confirm that SQL*Net is 
correctly configured.
    You say that one of the PC's works correctly. I would try to find out what 
is different about the VB configuration on that PC vs. the other two. I think 
that will likely correct the problem. Unfortunately, I can't tell you what to 
check on the Microsoft side. Are you using ODBC? 
   
  Dennis Williams


       
---------------------------------
Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. 

Other related posts: