VB4 Visigenic 32Bit ODBC driver connecting to Oracle 7
Quote:
>Here is my configuration:
>Windows 95, Visual Basic 4.0 Professional Edition, SQL*NET 1.1, ORACLE7
>TCP/IP
>I would like to connect to an Oracle 7 database using VB4 and the
>Visigenic 32bit ODBC driver.
>Question 1: Is it possible?
>Microsoft TechSupport says that Oracle has not released the required
>files?
Hmmmm - SO helpful, those MS folks....
Quote:
>Question 2: What IS required?
>Is a certain rev of SQL*NET required?
>Is a certain rev of Support files required?
>Visigenic faxed me a 4 page document on how to get it working.
>It required using REGEDIT to make changes!!!
Someone posted a fix on the comp.*.oracle newsgroup a couple times -
I just saw it again yesterday. HEY WAIT... I got it...
Here is his posting:
------------------- Begin ------------------
I think he's referring to my post. Here's the gist of it:
First, I'll assume that you have installed some sort of SQL*Net under
Windows 95. I have SQL*Net 1.x installed. I have not tried this solution
with SQL*Net 2.x but I received email from someone that did try and said
it will _not_ work...
The docs that come with VB 4.0 state that the Visigenic driver will be
installed if 3 DLLs are present on the system:
ORANT71.DLL
SQLNTTT.DLL
CORENT23.DLL
I put those on the Windows 95 machine, but that just let me install the
driver -- it still did not work, though. Then I discovered that when the
driver loads on NT, it also loads a DLL named SQLTCPNT.DLL. The whole
problem with the Visigenic driver is that it wants a 32-bit implementation
of SQL*Net. It seems that the SQLTCPNT.DLL file _is_ the 32-bit SQL*Net
driver. I copied that file over to my Windows 95 machine and now it works
just fine.
Gary
--------------------
Gary Weinstein
--------------------- end ----------------------
--
==============================================================================
"Visit the Hydrologic Information Center at http://www.nohrsc.nws.gov/~hic"
==============================================================================
