Crystal Reports Query

[kev2021]

Hi all,

Anyone familiar with Crystal Reports?

Basically my proposed setup is as follows:-

Windows 2022 server 64 bit

mysql server 8.0.27 64 bit

Windows 10 64bit  client running crystal reports 11 32 bit(?)

Now, question is – Assuming Crystal Reports 11 is 32bit (which I think it is) can that use the

mysql 64bit ODBC driver to connect to the 64 bit database?

Alternatively, can it use the 32 bit ODBC driver to connect to the 64 bit database?

if not, I’ll have to find a 32bit version of mysql server to install but I think mysql are looking to drop 32bit versions….

Thanks

Kev

 

Share the knowledge

You need to login in order to vote

[UK Sentinel]

Wow, I remember Crystal reports back in the day, V11 was way back in 2004

SAP Crystal Reports 2020 v14.3 is 64 bit (not much help I know)

I read that Crystal Report XI R2 will work with Windows 10 64 bit OS – but regarding the use of  mysql 64bit ODBC driver to connect to the 64 bit database is preferable, which is not suitable with crystal Reports v11 (32 bit)

So I read that you can (as you say) use a 32 bit ODBC driver to connect to the 64 bit database or uninstall the 64 bit version of ODBC ll Administrator etc.

.’. I would use the 32 bit driver when the client application or process is also 32 bit

 

(never tested this, but best guess I am afraid and does sound logical)

 

Ref:

https://answers.sap.com/questions/9192960/problem-with-odbc-connections-in-crystal-report-xi.html

Share the knowledge

In a completely sane world, madness is the only freedom (J.G.Ballard).

You need to login in order to vote

[kev2021]

Thanks for confirming suspicions Crystal reports 11 is 32bit, so now the question is, will the MySQL 32bit ODBC connect to a MySQL Server 64bit database OR will I need to use MySQL Server 32bit database?

I’ve not found a definitive answer on that and trying to avoid “trying it” for then needing to uninstall if it goes wrong and potentially run into problems if uninstaller doesn’t remove everything…

Thanks

Kev

 

Share the knowledge

You need to login in order to vote

[UK Sentinel]

kev2021 wrote:

will the MySQL 32bit ODBC connect to a MySQL Server 64bit

From what I read online, it should do, no harm in trying as only minor change, easy to revert back again and the least worst of the two options to try first.

(good opportunity to answer question definitively)  and to guide others also

Share the knowledge

In a completely sane world, madness is the only freedom (J.G.Ballard).

You need to login in order to vote

[kev2021]

Hi all,

So did a test tonight and in summary yes, ODBC 32 bit will talk to the MySQL 64 bit database server.  The crystal reports 11 (32 bit) wont see the ODBC 64 bit driver to connect to the server with so hence using 32 bit works ok.

One downside is, previously I used to copy the data folder which contains all my DB files over to the new server (stopping MySQl service first and then starting once copied over).  It seems this doesn’t work with MySQL 8.0.  If i copy 1 folder from MySQl 5.6.x to MySQL 8.0 and restart the service it fails to start, move the folder out and it starts fine.

So potentially a issue with the 32bit db files being copied into a 64bit installation?

I have overcome this by simply registering the new Db server in my MySQL client I use and then copying the database over to the new server via that – bit cumbersome doing each Db at a time but I only did 1 as I have setup a test server just to verify what works/doesn’t work.

I noticed then that when checking the actual files, the files on MySQL 8.0 doesn’t have a .frm on some of them like on 5.6.x so I’m wondering if that has something to do with it.

At present, my backup system is to simply stop MySQL, copy the data folder to my nas and then start the service as this has always worked ok but i’m now not sure it will work on MySQL 8.0 so may need to find a new plan.  Some of my DBs are ok as I work on them locally then copy up to hosting site but others are local use only so no other copy, hence my easy solution of copying the data folder so will need to look into this more as maybe once they are all in the MySQl 8.0 format, i can simply copy the data folder again and all will be will, could simply be a difference from 32 bit to 64bit but not familiar with that at the moment.

Thanks

Kev

Share the knowledge

You need to login in order to vote

[UK Sentinel]

kev2021 wrote:

So did a test tonight and in summary yes, ODBC 32 bit will talk to the MySQL 64 bit database server.  The crystal reports 11 (32 bit) wont see the ODBC 64 bit driver to connect to the server with so hence using 32 bit works ok.

That is both interesting and good new that ‘ODBC 32 bit will talk to the MySQL 64 bit database server‘

Thanks for sharing

Share the knowledge

In a completely sane world, madness is the only freedom (J.G.Ballard).

You need to login in order to vote

[kev2021]

Hi,

Thanks, no problem at all :)

So now my question is, does anyone know how to import ALL database on mysql 5.7.x 32bit to mysql 8.0 64bit?

I have a fair number of databases and would sooner not have to copy each database from mysql 5.7 to mysql 8.0 individually.  Would live to be able to copy All databases from mysql 5.7 to mysql 8.0 (excluding inbuilt databases ofcourse).

Thanks

Kev

Share the knowledge

You need to login in order to vote

[UK Sentinel]

kev2021 wrote:

does anyone know how to import ALL database on mysql 5.7.x 32bit to mysql 8.0 64bit

Alas not my area of expertise, hopefully others can advise ?

Share the knowledge

In a completely sane world, madness is the only freedom (J.G.Ballard).

Liked by:

You need to login in order to vote

[kev2021]

Fingers crossed :)

Kev

Share the knowledge

You need to login in order to vote

[Author]

Posts