Hi everyone. This is my first post here, apologies if this has been discussed before.
I am using VB6 Enterprise (which I am fairly new to) to connect to an Oracle 7 database, via ODBC, using DAO, using a Jet workspace (I am using a Jet workspace because the application also talks to other databases).
The Oracle database has two schemas, I'll call them User1 and User2. Some table names are duplicated across the two schemas.
In SQL*Plus, if I want to select a record explicitly from a table in another schema, I can use an SQL statement like:
select * from User2.ATable
However when I try this in my VB app I get an error message like:
"The Jet engine cannot find c:\ALongPath\User2.mdb"
I guess this means it thinks User2 is another database, not another schema in the same database. I have noticed the same problem in the VisData application that is supplied with VB6 (which also uses DAO).
Does anyone know how to access other schemas explicitly? I suspect that it's just another clause in my SQL statement or something else completely obvious that I just don't know about...
Thanks for your help
Colin Bell
