problem

Hello,

I have an apllication on:
PowerBuilder 6.5.1
ODBC MySQL 3.51.12
MySQL Server 5.0.18 win32 On windows NT Server 4.0 SP6

I have a problem with ODBC connector (I tink) when i try to access to MySQL.
My aplication connect to MySQL server and make all INSERTS, UPDATES and
SELECTS perfectly, but i have detected a problem. While a client makes a
modification on the Database, the other clients don't view de modifications
on time. The other clients must to disconnect and reconnect (exit the
program) another time to view the modifications. I see an option on ODBC
Driver called "Don't cache Result" that I think is the problem.

Its possible that the apllication queryes save on Local Machine client, on a
disk part chache on local. When I check this option on ODBC driver the
program finish with an error.

Do you help me?
Thank you