Help with embedding MySql into C# .net windows App
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
-
- Posts: 11
- Joined: Thu 03 Jul 2008 08:32
How to Configure embedd..
Hi i am using mysql community server 6.0 i am facing problem while its configuration for embedded server. I followed all the steps specified in documentation and also providing proper connection string but i am finding error: Error Occured while initializing embedded server. Heres my program's connection string:
"User Id=root;Database=padprotodb;Direct=False;Embedded=True;Persist Security Info=True;Connection Timeout=10000;Server Parameters=\"--basedir=f:/server/embedded/;--datadir=f:/server/embedded/data/;\"";
kindly help me to sort it out as soon as possible thanks.
"User Id=root;Database=padprotodb;Direct=False;Embedded=True;Persist Security Info=True;Connection Timeout=10000;Server Parameters=\"--basedir=f:/server/embedded/;--datadir=f:/server/embedded/data/;\"";
kindly help me to sort it out as soon as possible thanks.
-
- Posts: 43
- Joined: Thu 19 Jun 2008 14:30
There are just two conditions for Embedded server to function in deployed application:
1. libmysqld.dll file should be accessible for your executable file. It may be a good idea to distribute libmysqld.dll in the same folder with your application exe file.
2. The basedir and datadir variables must be set correctly. If the settings are invalid you will receive System.ApplicationException.
1. libmysqld.dll file should be accessible for your executable file. It may be a good idea to distribute libmysqld.dll in the same folder with your application exe file.
2. The basedir and datadir variables must be set correctly. If the settings are invalid you will receive System.ApplicationException.
-
- Posts: 11
- Joined: Thu 03 Jul 2008 08:32
Embedded server configuration
hi i am providing libmysqld.dll at debug folder of my program as well as through path variable but its not working
and for basedir i creaded a folder with the name of embedded and i paste share folder and data folder of mysql server at this place and while connecting i am providing --basedir=f:/server/embedded/;--datadir=f:/server/embedded/data/; this string as a server parameter in mysqlconnection properties but still its not working fine please help me out to how to configure mysql embedded server thanks. Regards,
Muhammad Saqib.
and for basedir i creaded a folder with the name of embedded and i paste share folder and data folder of mysql server at this place and while connecting i am providing --basedir=f:/server/embedded/;--datadir=f:/server/embedded/data/; this string as a server parameter in mysqlconnection properties but still its not working fine please help me out to how to configure mysql embedded server thanks. Regards,
Muhammad Saqib.
-
- Posts: 11
- Joined: Thu 03 Jul 2008 08:32
Hi i am facing a problem while accessing data from embedded database server. when i try to fetch data through mysqldatatable or mysqldataset component of core lab (mydirect) I found an error message. "Incorrect information in file :\server\embedded\data\mydatabase\xyz.frm".
Please help me to resolve this problem as soon as possible thanks,
Please help me to resolve this problem as soon as possible thanks,
I think that the problem may be in compatibility between different 6.0 versions of desktop and embedded MySql servers. Try to create test tables against the MyDirect connection from script, not by copying them from the desktop server folder. Than perform your SQL queries on those test tables. If the error is reproduced with this test script, please send it to us and we will deal with it.