
Connecting from VB3.0 to Access2.0 via ODBC
Quote:
>Subject: Re: [Q] Connecting from VB3.0 to Access2.0 via ODBC
>Date: 19 Jan 1995 16:26:13 GMT
>>: : We are trying to use the OpenDatabase Statement to open an
>>: : Access2.0 database using ODBC.
>>: : set MyDB = OpenDatabase("",false,false,"ODBC;")
>>: : After we select the Access2.0 database we get Error No: 2034
>>: : which has no documentation.
>--Mark!
>------------------------------------------------------------------------------
I have ran into the same problem ,
I have done some looking around on this and as far as I have found is
from MSKB: DOCUMENT:Q117900 18-OCT-1994 [VBWIN]
-2034 You cannot use ODBC to attach an external Microsoft
Access or ISAM database table to your database.
this error is in the Access 2.0 help files under "error messages: reference"
as far as I can tell VB-Access engine thinks it is creating an ODBC connection
to a SQL-server.
I have the new ODBCadrivers on the system and and can preform querys on
the ODBC data base via Excel, therefore I think the problem is in VB and the
way it connects to the ODBC subsystem.
If anyone has made this thing work let me know cause it would be a great
help to get ODBC working with my VB apps.
Kent
Dept of Agricultural Economics | GTE-Net: Office: 317-494-7642 Fax 317-494-9176
Purdue University | GTE-Net: Home: 317-497-4240 Fax 317-497-4152
West Lafayette, IN 47907 | Administrivia: #include <standard_disclaimer.h>