How to deploy MySQL application?

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
roky009
Posts: 3
Joined: Tue 30 Jul 2013 12:37

How to deploy MySQL application?

Post by roky009 » Tue 30 Jul 2013 12:42

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
Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: How to deploy MySQL application?

Post by DemetrionQ » Tue 30 Jul 2013 15:32

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
Posts: 3
Joined: Tue 30 Jul 2013 12:37

Re: How to deploy MySQL application?

Post by roky009 » Thu 15 Aug 2013 19:20

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

Re: How to deploy MySQL application?

Post by AndreyZ » Fri 16 Aug 2013 08:52

#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.

Post Reply