Inter-Platform MySQL and CR 10 (Closed)

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 :

Code:

---

Table " cannot be found

---

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

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?

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

Code:

---

TEXNIKOS

---

Under Linux, that same table was stored as

Code:

---

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.