MySQL Forums
Forum List  »  Delphi

BDE + MyODBC = Access Violation
Posted by: Gyorgy Szaszvarosi
Date: January 03, 2007 02:53PM

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

Options: ReplyQuote


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.