Connecting from VB3.0 to Access2.0 via ODBC 
Author Message
 Connecting from VB3.0 to Access2.0 via ODBC

: 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.

: Is this possible?  Can anyone help us?

: Thanks
: Leanne Stirling
: Megan Grenenger

Microsoft has a list of Reserved Error codes they faxed me.  Error -2034 is
concerned with trying to access MS Access via ODBC.  They promised me that
this will not happen when using something like SQL Server.  Try using
Access directly (not via ODBC).



Sat, 05 Jul 1997 05:40:22 GMT  
 Connecting from VB3.0 to Access2.0 via ODBC

: : 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.

You have the compatibility layer installed, right ? Installing this
allows a direct JET connection to Access 2.0 and has the wonderful side
effect of causing error -2034 with any ODBC connections. Uninstall the
compatibility layer and see if this fixes it.

---



Sat, 05 Jul 1997 13:51:20 GMT  
 Connecting from VB3.0 to Access2.0 via ODBC

Quote:



>: : 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.

I believe that this was posted earlier, but here goes anway...
Access 2.0 does NOT have an ODBC driver. I've heard Microsoft is working on one, but I
don't believe it is available yet. Therefore, you will not be able to connect to Access
databases using ODBC. If you have installed the compatibility layer, you can easily use
the JET engine.

Hope this help!

--Mark!

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



Tue, 08 Jul 1997 00:26:13 GMT  
 Connecting from VB3.0 to Access2.0 via ODBC


: >: : 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.
: >

: I believe that this was posted earlier, but here goes anway...
: Access 2.0 does NOT have an ODBC driver. I've heard Microsoft is working on one, but I
[snip]

Access 2.0 DOES have an ODBC driver. It is in the ODBC 2.0 Driver Fulfillment
Kit, available now directly from Microsoft. If you still don't believe it
Mark, I'll email you the Microsoft document which describes it. Check out
the knowledge base articles at ftp.microsoft.com, because several new
articles have been posted recently which discuss the 2.0 driver.

---



Tue, 08 Jul 1997 04:20:38 GMT  
 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>



Sat, 12 Jul 1997 12:16:16 GMT  
 Connecting from VB3.0 to Access2.0 via ODBC
: >>: : After we select the Access2.0 database we get Error No: 2034
: >>: : which has no documentation.

:   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.

We had a VB app talking to Access 1.1 via ODBC. It worked fine until the
compatibility layer was installed - then we got error -2034.
Try uninstalling the compatibility layer - using Microsoft's wonderful
uninstall program ;-)

---



Sun, 13 Jul 1997 01:38:13 GMT  
 Connecting from VB3.0 to Access2.0 via ODBC

Quote:


>Subject: Re: [Q] Connecting from VB3.0 to Access2.0 via ODBC
>Date: 24 Jan 1995 17:38:13 GMT
>We had a VB app talking to Access 1.1 via ODBC. It worked fine until the
>compatibility layer was installed - then we got error -2034.
>Try uninstalling the compatibility layer - using Microsoft's wonderful
>uninstall program ;-)
>---


 This note was on CIS

If you are using JET 2.x you CAN NOT connect to an
Access database using an ODBC driver unless you are
coding directly to the ODBC API. There are no
advantages that I can think of in trying to use an ODBC
driver to connect to an Access database. Use JET to
go to an Access database and use an ODBC connection
to go to other databases, your code is not going to
change if you switch from an Access database to SQL
Server using an ODBC driver.

Hope this helps.

Greg Hinkel
Microsoft Developer Support


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>



Sun, 13 Jul 1997 11:16:31 GMT  
 Connecting from VB3.0 to Access2.0 via ODBC
To connect to Access 2.0 from VB3.0 with the Access compatability layer
installed it is necessary to get the Version 2.0 ODBC drivers from
Microsoft... They charge about $10.50 and allow you to distribute it with the
software you develop....



Quote:
>Subject: Re: [Q] Connecting from VB3.0 to Access2.0 via ODBC
>Date: 24 Jan 1995 17:38:13 GMT

>: >>: : After we select the Access2.0 database we get Error No: 2034
>: >>: : which has no documentation.
>:   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.
>We had a VB app talking to Access 1.1 via ODBC. It worked fine until the
>compatibility layer was installed - then we got error -2034.
>Try uninstalling the compatibility layer - using Microsoft's wonderful
>uninstall program ;-)
>---




Mon, 21 Jul 1997 01:46:28 GMT  
 
 [ 8 post ] 

 Relevant Pages 

1. VB3 Problem connecting to Oracle via ODBC

2. Connect VB3.0 with Access2.0 database

3. Connecting from VB3.0 to Access2

4. Help: Conn. Access2.0 DB via ODBC

5. DAO - Connect to SQL Server via ODBC

6. Connecting a VB.Net to a database via ODBC

7. Anybody have info on connecting VB4 to Oracle via 16-bit ODBC

8. Connecting VB5 via ODBC to Informix

9. Connecting to Oracle via VB thru ODBC

10. Connecting to Oracle DB via VB (ODBC)...

11. Connecting to an Access 95 database via an ODBC driver in VB 5.0

12. oracle connected via odbc commits implicitly

 

 
Powered by phpBB® Forum Software