p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

pro_vb thread: Oracle Automation Error


Message #1 by "Reinhold Ohman" <rjohman@h...> on Tue, 10 Apr 2001 19:47:23
	Aw poop.  This definately exceeds my
VB-interfacing-with-Oracle-...-crap-I'll-just-use-Oracle-Developer knowledge
pool.  If you do figure out what the problem is, please post to the list.
I'm sure I wouldn't be the only one interested.

? Chuck

-----Original Message-----
From: Reinhold Ohman [mailto:rjohman@h...]
Sent: Wednesday, April 11, 2001 3:09 PM
To: professional vb
Subject: [pro_vb] Re: Oracle Automation Error


Chuck
This is not the case.  I am in fact using the same username/password for
login.  In fact, I use a login form to set up my connection and I type in
the same username/password.

> Check your connection object/DSN string for the user and password.
Ensure
> that user has SELECT access on that table.  It sounds to me that you,
using
> SQL Plus, might be using a different login than what your program is
using
> if SQL Plus works and the ODBC call does not.
>
> - Chuck
>


  Return to Index