Re: Can Not find table error

In article <MPG.195a1ba9b661c818989747_at_news.cis.dfn.de>, newspostings_at_hazelweb.co.uk says...
> In article <b87c466c.0306171908.5bb37cd_at_posting.google.com>,
> spebola_at_swbell.net says...
> > > Are you connecting to the same user that you were connected to when you
> > > created the table?
> >
> > Yes, I am using the same User Id and Password in the connection string
> > as I used in connect to the database in SQLPlus worksheet to create
> > the table. So that user id should be the owner of the table.
> >
> > The only reference I find in the OEM for the table "Cont" is the
> > schema, which is listed under the SYS node within the Schema Node. I
> > can insert data, select data and drop the table from the SQLPlus
> > Worksheet.
> >
> > Thanks for reading my post.
> >
>
> Connect as the user who created the table using sqlplus.
>
> Run this query:
>
> select object_name, object_type
> from user_objects
> order by object_name;
>
> and see if it shows up there.
>
> hth etc.
>
> If it doesn't show then you have almost certainly created the table in a
> different account.
>
> hth etc.
>
>
>
>

Misread something here - you are able to do everything to the table in sqlplus but your VB program, connecting to the same account, cannot - I wonder if there is some case-sensitivity issue here.

If you create a table like this:
  create table fred (x number);
the table will appear in the data disctionary as FRED

But:
  create table "fred" (x number);
the table will appear in the data disctionary as fred and to acces it you will need to e.g.

  select * from "fred";

Could a variation of this be your problem?

hth

cheers

-- 

jeremy
['75 RD250A] | ['02 Fazer 600 in blue]