How to deploy MySQL application?

[roky009]

Hi,
I made a program using C++ Builder XE 4 update 1 and Devart "dbxmda v.6.2.3".
until XE 3, i just install dbxmda file, but XE 4 I can't use my program..
So I'd like to know anything changed, or should i purchase more driver(s)..
Thanks in advance,
any clue will be very grateful..
Matt.

[DemetrionQ]

Hello.

Please describe the issue in more details. If any errors occur, provide the full error message text and description of situations they occur in.

If the issue only occurs when opening projects, created on another C++Builder version (for example C++Builder XE3), in C++Builder XE4, then the point is that C++Builder saves the whole list of runtime packages and libraries, registered in your IDE, to a *.cbproj file. Since the dbExpress driver for MySQL library name is different for different IDEs (for example, DbxDevartMySqlDriver170 - for XE3, and DbxDevartMySqlDriver180 - for XE4), you will get an error like "Unable to open file 'DBXDEVARTMYSQLDRIVER170.BPI'' when compiling a C++Builder XE3 project in С++Builder XE4. To solve the issue, edit the *.cbproj file of your project by replacing
DbxDevartMySqlDriver170
with
DbxDevartMySqlDriver180

[roky009]

Hi, I did all and I made all project with XE 4 version.
And I got error message as follows:

Remote error:
#42000You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right
syntax to use near "table_000" at line 1.

I made "Datasnap 2 tier application" and my local computer connected without any problem, but other machines can't get that connection. so... i lost ....

thanks anyway

[AndreyZ]

#42000You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right
syntax to use near "table_000" at line 1.

This error means that your SQL statement contains a syntax error. You can find the correct syntax of valid SQL statements for MySQL server in MySQL Reference Manual.