hello,
i have an app (WICH IS NOT MINE so i dont have source code) installed on 5 computers and a mysql server.
this app works with two tables from a mysql database (lets say table_A and table_B)
i need to change the server,so i made a backup of mysql database and put it on the new server,i created a mysql user to handle connections and i also changed the ODBC data source on the work machine with the new IP adress of server.
what is the problem?well with the new server i have connection to the database,i can write rows to it (using another app but same mysql connection string), i can view rows, BUT when i want to update a row it just updates table_A, leaving table_B with no changes.
i have made also a special right to my table , for example database.tableA with full rights to the user but it still doesnt updates.
the app worked fine on the old server.
i am thinking that maby there is an advanced thing to do that i dont know about
PS : actually it doesnt make an update on table_A , it just inserts the date and time that you made an update,so its just INSERT,but on table_B should do an UPDATE of the address..