Re: ODBC Problems with Oracle 7 AND Visual Basic

In article <42hffs$3fk_at_toplink1.toplink.de>, Stefan Fallet <stfallet_at_herrenberg.netsurf.de> writes:

> I'm having problems connecting via ODBC (Oracle or Intersolve) to an
> ORACLE 7 Database out of Visual Basic. The problem only occures if two
> users have tables with the same name. In this case Visual Basic tries to
> access the first table.
>
> Example:
>
> Users PROD1 and PROD2 have both a table by the name MYTABLE. If I try
> accessing MYTABLE from PROD2 I get the errormessage: error accessing
> PROD1.MYTABLE. If I try accessing MYTABLE from user PPROD1 it works.
>
> Any Solutions
>
> Stefan

this is a long shot but i have seen similar flaky behavior when forgetting to create the dynaset with option DB_SQLPASSTHROUGH...

HTH, david Received on Thu Sep 07 1995 - 00:00:00 CEST