Input string was not in a correct format

Input string was not in a correct format

Postby Morkai » Wed 10 Nov 2004 19:29

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

Re: Input string was not in a correct format

Postby Oleg » Fri 12 Nov 2004 14:30

This question has already been discussed in the forum.
Please see topic MySql 4.1 and v1.80.9.0
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL