VB30 <-<ODBC>-> Access 2.0
Quote:
Wynnytsky) writes:
> I'm using the Access ODBC driver version 2
> with ODBC21.EXE already installed on my system.
> I don't want to use the Access Jet engine.
> Ultimately I wish to switch to all ODBC API calls.
> I created an Access 2.0 data source called kiosk that points to my Access 2.0 DB.
> The Admin account is set properly because if I mess with the UID or PWD, I'm told
> that I have an invalid username or password.
> ***** CODE *****
> Dim db As database
> Set db = OpenDatabase("", True, True, "ODBC;DSN=Kiosk;UID=Admin;PWD=")
> db.Close
> ***** ERROR *****
> Reserved error (-2034); there is no message for this error.
The problem is that you cannot use the VB interface to get at Access defined as
an ODBC source for some reason - I believe JET interferes with the ODBC calls.
This is a shame, if you like to use the VB interface, since it means you can't
test out your applications locally before connecting to some other ODBC driver.
The solution is to bite the bullet and go straight for the ODBC APIs. I have
recently started investigating them helped by a very useful article in the
Jan '95 VBPJ - 'Optimizing ODBC' by Abndrew Brust. This article will get you
started, but you will sometime need the ODBC 2.0 Programmer's Reference
(about USD 25) and also sight of the sql.h and sqlext.h include files that come
with Visual C++ V 1.5. Best of all is to get the ODBC SDK, which unfortunately
only seems to be obtainable by joining the Microsoft Developers' Network level 2.
-------------------------------------------------------------------------------
Bruce Wassell
Oakley, Hampshire, England
