I am writing an Application that used a MySQL database and I have my test and Live database on the same server. Now when i created the report i used the Test DB and now that i would like to put my report over to the live DB it does not seem to work. I am using the MySQL 5.1 ODBC driver and i change the DB name there.
.
But once i change it the Crystal report still looks at the Test DB. I figured out that it is because in the "Tools>>Show SQL" it uses both DatabaseName.TblName and that causes it to keep looking at the Test DB instead of the one specified in the ODBC. Can anyone please help me with an answer as to how i can fix this.
I sat since Thurday last week trying to get this report to look at the live server.
IP Logged