Urgent Help - ODBC for Oracle through VB

The last two days I have been struggling to get VB to connect to an Oracle database. I included the Microsoft ODBC Driver for Oracle from the ODBC drivers in the control panels, then gave one of the user names used by Personal Oracle7 for the local database on my Windows95 machine (PO7, scott etc.). I could get to open the tables and fields without providing a connect string but when I typed any query in the SQL window of the 'Visdata window' of Visual Basic, it always looked for a table with a '*.mdb' extension though my DSN shows the MS ODBC driver for Oracle. Moreover, when I double-clicked on any particular table, the error 'ODBC connection failed - error 3146' propped up.

i) Also, when the MS ODBC driver for Oracle setup window comes up, there

are DSN, user id, password, Database, Driver and server fields. What do I need to type in each ?

ii) How do I get the ODBC connection to recognize and execute queries on

*.ora files (Oracle files)or the tables opened in the window besides the

SQL window ?

iii) Is there any particular statement that I need to code in Visual Basic and if so, when and where do I do it ?

iv) Do I have to set any data sources for the MS ODBC driver for Oracle in the 'control panels' when I configure it initially to access the local database ?

v) The ODBCINST.INI file suggests that the driver for the MS ODBC driver

for Oracle is the C:\WINDOWS\SYSTEM\MSORCL10.DLL but the entries in the driver field of the ODBC driver setup window seems to be limited in the form of a combo box and I am not able to enter this value - what do I do

?

Any help towards any question would be appreciated as I am working on a project involving ODBC which I need to complete within the next week.

Thanks,

Sriram Received on Wed Sep 23 1998 - 11:46:55 CDT