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
>