Input string was not in a correct format

[Morkai]

Using MySql 4.1 and MySqlDirect version 1.80.9.0

An ExecuteScalar command that works perfectly with MySql 4.0.13 is now giving me an exception when I try and connect to my new 4.1 database.

Dim strSql As String = "SELECT trialby FROM tblTrialBy"
Dim sqlCmd As MySqlCommand = New MySqlCommand(strSql, MySqlConn)

sqlCmd.ExecuteScalar()

Exception thrown:
System.FormatException: Input string was not in a correct format.

I'm confused, its just simple select statement.

[Oleg]

This question has already been discussed in the forum.
Please see topic MySql 4.1 and v1.80.9.0