Problems with connecting to embedded server

alexbaeu · Post by **alexbaeu** » Fri 05 Nov 2010 09:09

I'm evaluating dotconnect for MySQL with my VB .Net application.
The application has 2 modes, using MySQL Server and embbeded Server, version 4.1

Access to the server works fine.
I just use
Imports Devart.Data.MySql
instead of
Imports MySql.Data.MySqlClient
and the application still works.

With embedded server I get no connection. The application ends without error or exception in the try block during execution of DBConn.open()
There is no database existing so far. This should be created by my application after connection to the embedded server

Code: Select all

DBConn = New MySqlConnection
myConnectionString = "User Id=root; Server Parameters=""--basedir=" & workPath &  "; --datadir=" & dataPath & ";""; Embedded=True;" 
DBCmd = New MySqlCommand
DBCmd.Connection = DBConn
try
    DBConn.ConnectionString = myConnectionString
    DBConn.Open()
    ...
 Catch ex As MySqlException
    ...
 Catch ex As DataException
    .... 
End Try

Optionally I tried to use mysql.ini file in the work path of the application and set
myConnectionString = "Embedded=True;"
because ConnectionString must be set
This leads to an execpion "error initalizing embedded server"

Any hints/ideas how to solve this problem?

Shalex · Post by **Shalex** » Mon 08 Nov 2010 18:19

The Using Embedded Server article is here: http://www.devart.com/dotconnect/mysql/ ... erver.html.

We have answered you by e-mail.

alexbaeu · Post by **alexbaeu** » Mon 08 Nov 2010 18:27

Hello Shalex, thank You for the link. I have the document already and tries to configure as described. I can see that base and datadir are correcty, otherwise I would get an exception.

But I have still the problem that the application ends with the open command without any error. So I have no idea how to proceed.

Regards

Alexander

Shalex · Post by **Shalex** » Tue 09 Nov 2010 14:56

We have answered you by e-mail.