Re: ODBC 32 trouble

Problem is because the Visigenic driver was built to use the Oracle NT 32 Bit SQL*Net and look for file which Oracle document as changable. They should not look for files and use the documented API only. Visigenic now have a ODBC driver for SQL*Net 32Bit Win95. However, Oracle has now released an ODBC driver for SQL*Net 32Bit for WIN95 it is on the web site WWW.ORACLE.COM. There is bug in it where you have column size > then 255 and Oracle support have a patch.

Stephen Markham

> Michael Krolewski <mkrolews_at_upw.com> wrote in article
 <31E6C6B6.D25_at_upw.com>...
> Roman V. Eremin wrote:
> >
> > I have trouble to connect VB 4.0 to Oracle 7.2.2 (HP-UX) via
> > Visigenic 32 ODBC driver.
> > When I try to add Oracle datasource, following appears:
> >
> > Filed to load file vsorac32.dll
> > The Oracle(tm) client and networking components were not found. These
> > components are supplied by Oracle cotporationn [blah-blah...]
> >
> > Press Ok to exit, or Cancel to see whoch components are missing.
> >
> > When I press Cancel nothing appears.
> >
> > SQL*Plus 3.2 (32 bit) seems to work fine.
> > Does anyone have any suggestions?
> >
> > Roman Eremin
>
> This appears to be a problem with the latest ODBC driver.
>
> Under both win95 and win 3.XX, we were unable to get the latest and
> greatest ODBC driver to connect.
>
> We reverted to the 16 bit version (available in the Oracle for NT
> download from the Oracle Web page). Note the tnsname.ora file is not
> automatically constructed by the old system. The one generated by the
> new system works fine -- just save before the installation.
>
> Happy hunting.
>
> Mike Krolewski
>
Received on Tue Jul 16 1996 - 00:00:00 CEST