Results 1 to 7 of 7

Thread: Vb6 And Latest MySQL odbc driver

  1. #1

    Thread Starter
    Member
    Join Date
    Oct 2018
    Posts
    62

    Vb6 And Latest MySQL odbc driver

    Hello friends!

    Recently Oracle released the latest version of MySql, which called it 8.1.0 Innovation.

    Along with its release came the ODBC drivers that we normally use in applications built with Visual Basic 6.

    To my surprise, the most recent version of the ODBC Driver was compiled for 64-Bit platforms only. We will no longer have recent versions of the ODBC Driver compatible with Vb6.

    So we don't know if the older versions of these frivers will support the new MySql Server 8.1.0 Innovation and later versions. This is very bad. It would be a limitation for us, after all, who here has never used MySql Server?

    Also the latest version of MySql ODBC fixes a critical bug:

    Bugs Fixed
    Fixed a memory leak generated by reading data. (Bug #111036, Bug #35491247)

    https://dev.mysql.com/doc/relnotes/c...ews-8-1-0.html

    Is there any way to use 64bit MySql ODBC driver with vb6?

    https://dev.mysql.com/downloads/connector/odbc/

    Thanks!
    Last edited by hennyere; Jul 28th, 2023 at 06:07 AM.

  2. #2
    Hyperactive Member
    Join Date
    Mar 2019
    Posts
    468

    Re: Vb6 And Latest MySQL odbc driver

    Does it have any changes from the previous 32 bit version that you need?

  3. #3

    Thread Starter
    Member
    Join Date
    Oct 2018
    Posts
    62

    Re: Vb6 And Latest MySQL odbc driver

    Quote Originally Posted by vbwins View Post
    Does it have any changes from the previous 32 bit version that you need?
    Bugs Fixed
    Fixed a memory leak generated by reading data. (Bug #111036, Bug #35491247)

    https://dev.mysql.com/doc/relnotes/c...ews-8-1-0.html

  4. #4
    PowerPoster
    Join Date
    Jan 2020
    Posts
    4,458

    Re: Vb6 And Latest MySQL odbc driver

    How to use libmySQL.dll API to access MYSQL database in VB6.0-VBForums
    https://www.vbforums.com/showthread....abase-in-VB6-0
    dose libmySQL.dll have new version for 8.1?

  5. #5
    PowerPoster
    Join Date
    Jan 2020
    Posts
    4,458

    Re: Vb6 And Latest MySQL odbc driver

    Functionality Added or Changed
    Important Change: 32-bit binaries are no longer built as of MySQL 8.1.0.

    like micorosoft droped vb.net ,only c# will update

  6. #6
    Junior Member ricardoweb084's Avatar
    Join Date
    Mar 2024
    Posts
    18

    Re: Vb6 And Latest MySQL odbc driver

    How is this issue today? Is it possible to use MySql 8 with vb6 on a 64-bit Windows normally? I use DRIVER 3.51 until today, but I would like to use new SQl features.

  7. #7
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,784

    Re: Vb6 And Latest MySQL odbc driver

    Quote Originally Posted by ricardoweb084 View Post
    How is this issue today? Is it possible to use MySql 8 with vb6 on a 64-bit Windows normally? I use DRIVER 3.51 until today, but I would like to use new SQl features.
    AFAIK, Only up to MySQL8.0.37 provides 32-Bit ODBC-Driver
    You should still be able to connect to a MySQL 8.X.X, but you won't be able to use any new features after 8.0.37
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width