I am using a program called Syware VisualCE / mEnable to build database forms on a PDA that can synchronize with our MySQL server. When synchronizing through the PDA cradle, both the SQL and PDA tables successfully synchronize.
Quick background on mEnable: mEnable allows synchronization through the Internet (ie: connecting the PDA through a modem and synchronizing with the server D:cool:. mEnable works perfectly with Access. However, I am having a difficult time synchronizing to the MySQL DB.
After discussing this with the Syware technician, he stated that the MySQL ODBC 3.51 Driver does not appear to support ODBC bookmarking capability: SQLSetStmtOption(SQL_USE_BOOKMARKS).
Basically, how do I obtain a MySQL ODBC 3.51 Driver that supports ODBC bookmarking?