ORACLE7 schema names in MS Visual BASIC

Does anyone know how to specify ORACLE7 schema names in a SELECT statement executed from Microsoft Visual BASIC?

I receive the error message "'tom.mdb' isn't a valid path" when the following code is executed:

...

  Global db_test As Database
  Global ds_Address_List As Dynaset
  Global Const connect_string = "ODBC; "
...

  Dim SQL_Query As String
  SQL_Query = "SELECT street, city, state, zip FROM tom.address"   Set db_test = OpenDatabase("", False, False, connect_string)   Set ds_Address_List = db_test.CreateDynaset(SQL_Query, DB_SQLPASSTHROUGH)
...

The error message occurs when the "CreateDynaset" statement is executed. It doesn't matter what ORACLE ID is used.

When I modify the SQL statement to NOT specify the schema name, and log on to ORACLE as Tom, then it works just fine.

I know the ORACLE privilages are setup OK.

I am using ORACLE7 Server version 7.0.12.1.0 on a Netware 3.11 Server, SQL*Net SPX version 1.1.1.2, Microsoft Visual BASIC version 3.0 Professional,and the Oracle ODBC driver version 1.00.2816 that was included with Visual BASIC.

Thanks in advance!

Rick Grosek
Database Administrator
(605) 394-1297
South Dakota School of Mines and Technology rgrosek_at_msmailgw.sdsmt.edu
rgrosek_at_silver.sdsmt.edu Received on Wed Feb 23 1994 - 20:27:25 CET