HELP: ODBC with Access 2.0, VB3.0, and Data Control

HELP: ODBC with Access 2.0, VB3.0, and Data Control

Post by Steve Jackso » Sat, 06 Apr 1996 04:00:00



We have a client trying to use our ODBC "Spy" Driver with MS
Access 2.0.  Their development environment is MS Visual Basic
3.0.

Our "Spy" driver must use another ODBC driver to do the actual
interaction with the underlying database (just for a quick
explanation without disclosing any trade secrets! :-)

The Problem:
------------
In order to use ODBC, our client switched from using the Jet
Engine to using ODBC API calls within his VB project.  Things
ran smoothly until he tried to access his data from a data
control.  His error message said basically, "If you want to use
this data control with MS Access, you gotta use the Jet Engine."  
Apparently, it would work fine with a different database and
ODBC.

The Restrictions:
-----------------
Our client cannot invest any more time trying this with other
databases.  Our client does not have VB 4.0.  Our client does
not have MS Access 7.0.

We have VB 4.0 and MS Access 7.0, but do not have our client's
versions.

The Questions:
--------------
1) Does anybody know if this is really possible with Access 2.0
and VB 3.0?

2) Does anyone out there know of a data control that is "ODBC
Friendly" to MS Access?

3) On a different note:  Does anyone know of an ODBC driver for
MS Access that supports the SQLPrimaryKeys function?  The one I
have (from Microsoft) does not.

If I have been at all unclear in this post, please e-mail me and
I'll try to explain further.

Thank you for your time!

Please Note:  I've set Followups to the
comp.lang.basic.visual.database newsgroup.
--

 
 
 

HELP: ODBC with Access 2.0, VB3.0, and Data Control

Post by John Par » Sun, 07 Apr 1996 04:00:00


Hi,

I have been trying to use ODBC with Access within a VB
application, and have been unsuccesful, as VB returns with the
error saying that you cannot use ODBC on an ISAM database or
something like that.  It appears that you cannot use an Access
ODBC driver in VB applications.

Hope this helps,

JP

 
 
 

HELP: ODBC with Access 2.0, VB3.0, and Data Control

Post by Steve Tilso » Mon, 08 Apr 1996 05:00:00



> We have a client trying to use our ODBC "Spy" Driver with MS
> Access 2.0.  Their development environment is MS Visual Basic
> 3.0.

Why are they doing this at all? You are going nowhere with this so give them back their
money. If they are trying to figure out why a network app bogs the network or why a
query does not work right, etc, they need to employ a consultant that already knows
what, how, and why to do what is required of these type applications.
 
 
 

HELP: ODBC with Access 2.0, VB3.0, and Data Control

Post by Joe Foster of Bo » Wed, 10 Apr 1996 04:00:00



> We have a client trying to use our ODBC "Spy" Driver with MS
> Access 2.0.  Their development environment is MS Visual Basic
> 3.0.

[snip]

To avoid the "you must use Jet to open an Access database" error,
have the user temporarily de-install the Access 2.0 Compatibility
Layer. This will cause the VB app to use the Jet 1.1 engine,
which will open Access 2.0 ODBC data sources. The old VBDB300.DLL
file in particular file will have to be reinstalled from the
original VB 3 diskettes or CD.

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!

 
 
 

1. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

After I have installed the ms/Jet engine compatibility layer for the
visual basic 3.0 is not more successful to access data with the ODBC driver
interface .

I can still see my data base like access 2.0.
But when I try to access it like an ODBC data base
the sample program supplied by microsoft in
the c:\ vb\samples\ visdata returns a reserved error.

My data base is very simple.
It consists just in a table named as table1
where a text field is defined like unique key.

2. Sybase on HP K200 w/HP-UX 10.01 ?

3. Help: Problem connecting VB3 app to Access 2.0 w/ODBC in Win-OS/2

4. access SQL server in UNIX

5. Help: Problem reading Access 2.0 mdb from VB3 under Win95/Access 7.0

6. Access not disconnecting from Sybase

7. VB3 using Access 2.0 db thru ODBC

8. Unexpected condition- Table Buffer [l11] Paradox 4

9. VB3 / Access 2.0 problem with data lengths

10. Help w/VB3 and Access 2.0

11. HELP! VB3/Access 2.0

12. Help with VB3/Access 2.0 problem PLEASE!!!

13. HELP: Access 2.0/VB3 db Security