Connect to Database

[Vit Coufal]

Hi there,
I have the following issue.
I connect to Server Version 3.22.32 for the first time -> everything is ok
Then I connect a second time and get the following Error
<---SNIP
Eine nicht behandelte Ausnahme des Typs 'MySql.Data.MySqlClient.MySqlException' ist in mysql.data.dll aufgetreten.

Zusätzliche Informationen: Unknown command
--->SNAP

I guess a translation to english would something like
<---TRANSLATION
A non handled exeption occured of type 'MySql.Data.MySqlClient.MySqlException' occured in mysql.data.dll.

additional information: Unknown command
--->TRANSLATION


I use the following code connecting to DB.

<---SNIP
Private Sub connect_mysql()
'Me.dbconnMYSQL.ConnectionString = "Database=testdb;Data Source=192.168.2.8;User Id=xxx;Password=xxx;CharSet=latin1"
Me.dbconnMYSQL.Open()
MsgBox("Break")
Me.dbconnMYSQL.Close()
End Sub
--->SNAP

Now something that confuses me completly. I have a second Server running mysql Version 4.0.20. Using exactly the same code for connecting and disconnecting works fine!!
Does anyone has an idea? Don't tell me using the second server. That is impossible for now.

Cheers folks

Vit