topic Re: Change MySQL ODBC Driver version in Discussions

Change MySQL ODBC Driver version

mperuffo — Sat, 10 Jun 2023 20:45:09 GMT

I am trying to connect JMP to a MySQL database but JMP give me only the latest version of drivers even if on my machine I have the old version that is the only one compatible with the database.

I have installed the correct drivers and as you can see on the attached picture on the Admin tools I have the the 5.1 version that is compatible and I can connect the database to the system.

However when I use JMP I have only the 8.0 that is not compatible with the database.

Any idea how I can use a different drive version within JMP?

Re: Change MySQL ODBC Driver version

jthi — Fri, 21 May 2021 16:15:48 GMT

Could you be comparing 32bit and 64bit drivers by accident?

Re: Change MySQL ODBC Driver version

mperuffo — Tue, 25 May 2021 07:51:57 GMT

On the admin tool I am on the 32 panel and I have installed only the 32 version of mysql drivers

Re: Change MySQL ODBC Driver version

jthi — Tue, 25 May 2021 12:55:19 GMT

I think if you have 64bit JMP it will only look for drivers you can find from 64-bit ODBC Data Source Administrator. I'm not sure if there are any ways to look for 32bit drivers with 64bit JMP.

I think JMP support maybe be able to help you out with this one. You can contact them by sending email to: support@jmp.com

Re: Change MySQL ODBC Driver version

Jeff_Perkinson — Tue, 25 May 2021 14:34:02 GMT

@jthi is correct. The ODBC driver must match the "bitness" of the application using it. So, since JMP is 64-bit, the ODBC driver must also be 64-bit.

It looks like you might be able to download a 64-bit MySQL ODBC driver here.

Re: Change MySQL ODBC Driver version

mperuffo — Tue, 01 Jun 2021 10:01:40 GMT

Thanks, I installed the 64bit version of the same drivers and now I can find the driver on the JMP panel too.