Re: Oracle ODBC connection and VB4

Mark

> > Mark McCubbin wrote:
> > >
> > > I need my VB4 application to "talk" to the Oracle Local Database that
> > > resides on my desktop PC. When I try to open the database from my VB4
> > > app, I get the error message "Couldn't find installable ISAM."
> > >
> > > To setup the data source I double-clicked the ODBC icon in Control
> > > Panel, clicked the Add button, chose "Oracle ODBC Driver for Rdb,"
 and
> > > keyed in "Local Database" for data source name.
> > >

You do not need "Oracle ODBC Driver for Rdb" this is an ODBC driver for another RDBMS which use to be Digital's Rdb and Oracle had acquired it sometime ago (August or September 1994 - if my recollection is OK). What you need to use is Oracle73 driver (or Oracle7<n> driver where <n> is the version you have e.g. for Oracle 7.2 it is Oracle72 - you got the picture). If you do not have it you can either download it from oracle web site (I do not know exact URL of their download page, but if you search for ODBC driver you'll find it) or if you have Personal Oracle CD-ROM, it is there.

I have found using MS Access very useful to test wether ODBC connection works or not and to get connection string right (you can refer to other postings related to your question). Just try to attach table using ODBC.

Hope this helps. Good luck

Kresimir Fabijanic

Also Received on Tue May 20 1997 - 00:00:00 CEST