Help with embedding MySql into C# .net windows App

Postby CLIPER » Wed 18 Jun 2008 06:52

If we but the MyDirect.NET is that mean we can also have the source-code? or just the assembly?
CLIPER
 
Posts: 2
Joined: Sat 14 Jun 2008 11:27
Location: Philippines

Postby Alexey.mdr » Wed 18 Jun 2008 16:04

Hello,

Source code for MyDirect .NET are not available for sale.

Regards,
Alexey.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

How to Configure embedd..

Postby Muhammad Saqib » Thu 03 Jul 2008 12:06

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.
Muhammad Saqib
 
Posts: 11
Joined: Thu 03 Jul 2008 08:32

Postby anton.connect » Fri 04 Jul 2008 08:28

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.
anton.connect
 
Posts: 43
Joined: Thu 19 Jun 2008 14:30

Embedded server configuration

Postby Muhammad Saqib » Fri 04 Jul 2008 09:54

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.
Muhammad Saqib
 
Posts: 11
Joined: Thu 03 Jul 2008 08:32

Postby Muhammad Saqib » Tue 08 Jul 2008 05:40

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,
Muhammad Saqib
 
Posts: 11
Joined: Thu 03 Jul 2008 08:32

Postby AlexeyB » Tue 08 Jul 2008 08:30

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

Previous

Return to dotConnect for MySQL