Problems with connecting to embedded server

Problems with connecting to embedded server

Postby 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?
alexbaeu
 
Posts: 2
Joined: Fri 05 Nov 2010 08:44

Postby Shalex » Mon 08 Nov 2010 18:19

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

We have answered you by e-mail.
Shalex
Devart Team
 
Posts: 7533
Joined: Thu 14 Aug 2008 12:44

Postby 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
alexbaeu
 
Posts: 2
Joined: Fri 05 Nov 2010 08:44

Postby Shalex » Tue 09 Nov 2010 14:56

We have answered you by e-mail.
Shalex
Devart Team
 
Posts: 7533
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL