Inter-Platform MySQL and CR 10 (Closed)

[divined]

Hello everybody

I`ve built my application using MySQL 4.1 running under Windows. The application uses CR 10. Now, I tried switching the MySQL RDBMS to Gentoo Linux. I altered the System DNS connector to point to the Gentoo Linux machine. Unfortunately, many reports that used to work now turn out blank with the error :

Table " cannot be found

Why might that be so? Case sensitity of the Linux machine?

[divined]

No ideas? I`ve managed to pinpoint the failure to those queries which use Inner Joins. But why do they work fine under a Windows MySQL RDBMS and fail under a Linux MySQL RDMS, which furthermore are the same version. Anyone experienced similar problems?

[divined]

The problem was this :

Every integrated report holds information about the names of the tables that are being used. It so happened that these reports where created under Windows XP, which is a case insentitive OS. For example CR 10 stored a table as

TEXNIKOS

Under Linux, that same table was stored as

Texnikos

so that table could not be found under Linux. Rather simple error after all, but the process of editing 50 reports to get it right was rather tedious.