I have the Visual Basic 4.0 Enterprise Edition installed on an NT machine and
a Windows 95 machine.  Both machines have SQL*Net installed and SQL*Plus works
without problems.  On the NT machine I can use the Visigenic driver that came
with VB 4.0 and it works quite nicely.  However, on Windows 95 it does not
work -- I always gets an error when trying to log in.

The drivers were installed on both machines automatically as part of the VB
install procedure.  Is there something special that needs to be done on
Windows 95?

Thanks in advance for any help.

Gary Weinstein

The following "Appnote" is from the following URL at Microsoft:
http://198.105.232.6:80/KB/deskapps/access/Q139487.htm

Editorial notes by me are enclosed in [square brackets].

Bottom line:  SQL*Net 32-bit client certified for Windows 95
              is expected in late December 1995 or early
              January 1996.

-- Rick

INF: WX1220: ODBC Drivers Appnote

ARTICLE ID: Q139487

---------------------------------------------------------------------------

The information in this article applies to:

 - Microsoft Access versions 2.0, 7.0

 - Microsoft Excel for Windows 95

 - Microsoft Word for Windows 95

 - Microsoft Office for Windows 95

 - Microsoft Project for Windows 95

 - Microsoft Visual FoxPro(tm) version 3.0

 - Microsoft Visual Basic(r) version 4.0

 - Microsoft C++ version 4.0

---------------------------------------------------------------------------

This Application Note contains the latest Microsoft Open Database

Connectivity (ODBC) drivers for the following data sources:

 - ORACLE version 7.0

 - Microsoft SQL Server versions 4.21 and 6.0

 - Microsoft Jet database engine version 3.0, which supports the following

   formats:

      Microsoft Access versions 2.0 and 7.0

      Microsoft FoxPro versions 2.0, 2.5, and 2.6

      dBASE III, dBASE IV, and dBASE(r) for Windows

      Paradox versions 3.x, 4.x, and 5.0

      Microsoft Excel versions 3.x, 4.x, 5.x, and 7.0

      Text

You can obtain this Application Note from the following sources:

 - The Microsoft Network

 - CompuServe, GEnie, and Microsoft Partner Network (MSPN)

 - Microsoft Download Service (MSDL)

 - The Internet (Microsoft anonymous ftp server)

 - Microsoft FastTips Technical Library

 - Microsoft Product Support Services

For complete information, see the "To Obtain This Application Note" section

at the end of this article.

THE TEXT OF WX1220

---------------------------------------------------------------------------

  Microsoft(R) Product Support Services Application Note (Text File)

                    WX1220: MICROSOFT ODBC DRIVERS

---------------------------------------------------------------------------

                                                  Revision Date: 11/95

                                                      2 Disks Included

The following information applies to Microsoft Access for Windows(R)

95, version 7.0.

---------------------------------------------------------------------------

              Note About the Microsoft License Agreement

In using this software product you implicitly agree to the terms of

the applicable license agreement, which follows at the end of this

Application Note.

---------------------------------------------------------------------------

Introduction

---------------------------------------------------------------------------

This Application Note contains the latest Microsoft Open Database

Connectivity (ODBC) drivers for the following data sources:

 - ORACLE(R) version 7.0 (distributed only with WX1220)

 - Microsoft SQL Server versions 4.21 and 6.0

 - Microsoft Jet database engine version 3.0, which supports the

   following formats:

    - Microsoft Access versions 2.0 and 7.0

    - Microsoft FoxPro(R) versions 2.0, 2.5, and 2.6

    - dBASE III(R), dBASE IV(R), and dBASE(R) for Windows

    - Paradox(R) versions 3.x, 4.x, and 5.0

    - Microsoft Excel versions 3.x, 4.x, 5.x, and 7.0

    - Text

Installation Requirements

---------------------------------------------------------------------------

The ODBC drivers are 32-bit only and are designed for use by ODBC-

compliant, 32-bit programs running under Microsoft Windows 95 or

Microsoft Windows NT(TM) 3.51.

To set up the ODBC drivers, you must have one of the following 32-bit

ODBC-compliant programs installed on your computer:

 - Microsoft Access for Windows 95

 - Microsoft Excel for Windows 95

 - Microsoft Word for Windows 95

 - Microsoft Office for Windows 95

 - Microsoft Project for Windows 95

 - Microsoft Visual FoxPro(TM) version 3.0

 - Microsoft Visual Basic(R) version 4.0

 - Microsoft C++ version 4.0

To use the ORACLE 7.0 ODBC drivers, you must have a 32-bit version of

SQL*Net(R) installed on your computer. For information about obtaining

the 32-bit version of SQL*Net, please contact Oracle Corporation at

(800) 345-DBMS.

[Note from Rick Rutt:  I called this 800 number at Oracle Corp.,
                       and learned that the 32-bit SQL*Net client
                       for Windows 95 is expected to be available
                       in late December 1995 or early January 1996.]

[Installation instructions deleted.]

This Application Note includes the following three driver-specific

Help files:

 - The ODBC SQL Server Help file (Drvssrvr.hlp) contains information

   about adding, modifying, and connecting to Microsoft SQL Server

   data sources, connection string attributes, and ODBC conformance

   levels.

 - The ODBC Desktop Database Drivers Help file (Odbcjet.hlp)

   contains information about adding and modifying Microsoft Jet

   database engine data sources, connecting to and deleting data

   sources, and levels of ODBC conformance. The Odbcjet.hlp file

   contains a "Product Support" topic with details about ODBC

   support offerings from Microsoft. The Odbcjtnw.hlp file is a

   subset of the Odbcjet.hlp file and describes new feature of the

   ODBC drivers.

 - The Visigenic ODBC ORACLE Driver Help file (Oracle.hlp) contains

   information about adding, modifying, and connecting to ORACLE

   version 7.0 data sources, connection string attributes, and

   levels of ODBC conformance.

---------------------------------------------------------------------------

END-USER LICENSE AGREEMENT FOR MICROSOFT SOFTWARE

[See the above URL for the EULA text.]

says...

And Rick Rutt said:

Well, I got the Visigenic driver to work on Windows 95!  The docs say:

The Oracle driver is installed automatically if the following three drivers
are present on the user's machine:  

        ORANT71.DLL
        SQLNTTT.DLL
        CORENT23.DLL

What it doesn't say is what Rick said -- you need a 32-bit SQL*Net driver.  
On my NT machine I had installed the WorkGroup Server and, therefore, had
such a driver.  I discovered that my database programs on NT were loading
the SQLTCPNT.DLL file, so I just copied that to my Windows 95 machine and
now I can connect from there as well.

It should be stated that I have managed to reproduce this on several
machine and that all of the machines in question are running SQL*Net 1.x.  
I have no idea if this would work for SQL*Net 2.x.

Gary Weinstein