Embbeded nysql problem

mikrodidakt · Post by **mikrodidakt** » Mon 26 Jun 2006 19:39

Hi!

This is what i found about how to use MyDac with the embbeded MySQL
A typical structure of folders for an application using Embedded Server:
Project.exe - executable file of your application
libmysqld.dll - MySQL Embedded server library
share/english/errmsg.sys - file with MySQL Embedded server messages
data/ - data directory (DataDir). See a structure of this folder in
MySQL Reference Manual
data/mysql/ - directory with service data of MySQL (user access rights,
and so on)
data/DataBase/ - directory with user data. See
TCustomMyConnection.DataBase

And this is what i have done:
1) Created a dir for the project (EmbMySQL)
2) Placed the project file EmbProject.cpp in this dir
3) Placed the libmysqld.dll in this dir
4) Copied the dir share from my MySQL server to the project dir
5) Copied the data dir from my MySQL server to the project dir
the data dir has the mysql dir with thee mysql database and
the database that i will use in my application

The problem is that when i change the propertie active to true in TMyTable
i get following error:
Incorrect information in file: C:\Program\Borland\CBuilder6\Projects\EmbMySQL\data\notetest\affar.frm

Antaeus · Post by **Antaeus** » Tue 27 Jun 2006 09:29

Possibly you use incompatible versions of MySQL Server and MySQL Embedded. Please specify exact versions of both.

mikrodidakt · Post by **mikrodidakt** » Tue 27 Jun 2006 20:25

thanks i will look in to that