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

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 Received on Fri Sep 19 2003 - 02:55:46 CDT