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 Panels 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
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