Re: ORA-00942: table or view does not exist when updating recordset using Oracle ODBC

In article <2d83b9f.0309182355.1dd0779f_at_posting.google.com>, matsla_at_hotmail.com says...
> Hi!
>
> We are moving from Microsoft ODBC driver to Oracle 9.2 ODBC driver on
> an existing VB6 application using RDO. The only problem we get is when
> updating a recordset if the schema owner + tablename > 30 characters.
> The table name is 25 chars long. The problem is we must include the
> schema owner due to security. It's no problem to create a recordset on
> the same table and just step through the result. One workaround is the
> change all statements to ( INSERT INTO ... ) but it's a lot of code.
>
> rs.AddNew
> rs!.... = xxx
> rs.Update
>
> => ORA-00942: table or view does not exist
>
> Any ideas?
>
> // Mats
>

Another solution would be to use synonyms:

create synonym myschema.prods
 for myschema.tbl_products_really_long_name

insert into myschema.prods (...)

• Tom