Please Help - Oracle, ODBC, Visual Basic

I could get my Personal Oracle7 tables to open from Visual Basic by using the Microsoft ODBC driver for Oracle with the data source name as local and no connect string. I could see that this ODBC driver was different from the Oracle ODBC driver for Rdb (remote databases) in the Control Panel which could be configured with a connecting string '2:', data source name : 'Frayed Wires' and only this Microsoft driver could help me open my Oracle tables through Visual Basic.

But I still have the problem - when I frame a query and try to execute it in the SQL window of the Visdata program (for example on 'Scott.emp' table), it looks for 'Scott.mdb' and not the Oracle table and hence I am not able to execute it. However, the Data Form Designer works and I can read, update, add, delete, refresh records in this 'Scott.emp' file with the buttons and data control in the form opened through the 'Data Form Designer'.

How do I get my queries to recognize the Oracle tables and execute in the SQL Window of Visdata ? Do help me with anything you know about this.

Sriram Received on Sat Sep 26 1998 - 16:27:21 CDT