VS 2008 - How to connect to Embedded MySQL database?

[senglory]

How can I do it?

[Shalex]

Please refer to http://www.devart.com/dotconnect/mysql/ ... erver.html.

[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?

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

[senglory]

Throws "Unknown connection string parameter Embedded." What's wrong with it?

[senglory]

Any luck with the issue?

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

[senglory]

Here's my project with MYSQL data folders
http://zalil.ru/29687643

DevArt COnnect with the same version, 5.80.152.0

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