BDE + MyODBC = Access Violation
Hi Everyone,
I am trying to add MySQL access to an existing BDE (paradox) db application (written in BCB6/VCL). All seemed fine, until I got to the point where DELETE or UPDATE queries were applied to the MySQL data table. They either quietly fail, or Access Violation and crash.
The same thing happens when I try to execute the same (very simple) queries through Database Explorer, or even DataBase desktop. Even a simple query like:
UPDATE ":remoteDB:data"
SET Field1="aaa"
will do it. (from the context of a local alias, so standard Local SQL syntax is accepted. BTW, I need this as the whole purpose is to synchronize a local DB with the remote server)
Has anyone encountered this problem, and (even better) found a solution? I need to use BDE as the rest of the SW works on local Paradox Tables, and I do not wish to redo years of development for switching to another data access...
All help will be greatly appreciated.
Gyorgy
Subject
Written By
Posted
BDE + MyODBC = Access Violation
January 03, 2007 02:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.