Page 1 of 1
VS 2008 - How to connect to Embedded MySQL database?
Posted: Sat 21 Aug 2010 08:01
by senglory
How can I do it?
Posted: Sat 21 Aug 2010 08:30
by Shalex
Doesn't help
Posted: Tue 14 Sep 2010 05:55
by senglory
Wrote the following connection string:
Code: Select all
Public Const CONNECTION_STRING_TEMPLATE As String = "User ID=root; Server Parameters=\""--basedir=c:/mysql/;--datadir=c:/mysql/data/;\""; Embedded=True;"
Got the following error:
"Unknown connection string parameter --datadir."
What's wrong with my connection string?
Posted: Wed 15 Sep 2010 10:07
by Shalex
In C# and VB, double quote (
") marks a start/end of a string literal. If you want to tell the compiler to consider
" as a part of string itself, it is necessary to use
\" (additional backslash) in C# and
"" (additional double quote) in VB.
Please try the following connection string:
Code: Select all
Public Const CONNECTION_STRING_TEMPLATE As String = "User ID=root; Server Parameters=""--basedir=c:/mysql/;--datadir=c:/mysql/data/;""; Embedded=True;"
We will add a sample for Visual Basic to the Using Embedded Server article.
Doesn't help at all
Posted: Wed 15 Sep 2010 14:53
by senglory
Throws "Unknown connection string parameter Embedded." What's wrong with it?
Posted: Thu 16 Sep 2010 15:14
by senglory
Any luck with the issue?
Posted: Thu 16 Sep 2010 15:44
by Shalex
I cannot reproduce the error with the 5.80.152 version of dotConnect for MySQL. Please specify your version (the Tools > MySQL > About menu of Visual Studio) and post here your connection string.
Posted: Thu 16 Sep 2010 17:39
by senglory
Here's my project with MYSQL data folders
http://zalil.ru/29687643
DevArt COnnect with the same version, 5.80.152.0
Posted: Fri 17 Sep 2010 11:13
by Shalex
I can reproduce the "Unknown connection string parameter Embedded." error only using Express Edition of dotConnect for MySQL. Please refer to dotConnect for MySQL
edition matrix: the Embedded Server support is available only in the Developer, Professional, and Standard editions.