Unable to convert MySQL date/time value to System.DateTime

[Paramount]

Hello! This is mine code:

 

                    {
                       "server=",
                       this.textBox_host.Text,
                       ";User id=",
                       this.textBox_user.Text,
                       ";Password=",
                       this.textBox_password.Text,
                       ";database=" ,
                       this.textBox_db3.Text
                     });

 

I guess the problem could be in createtime table, because it has datatime is null (0000-00-00 00:00)

 

Any idea how to fix this problem?

[Wizatek]

Yes that is a problem, and there isnt much u can do about this because the mysql connector recognises this as invalid and will throw a exception.

The only thing u can do is change the database to have a valid datetime in thet field

[Paramount]

Yep, but I have found something:

 

convert zero datetime=True
 

Do you know where to paste it, and is it possible?

Thanks in advanced!