I routinely run a import script written in VB that connects to my MYSQL server and imports data into tables.
I did not write this script, nor am I familiar with the Visual Basic scripting language. So I would really appreciate some help.
Our MYSQL database is hosted and managed in the cloud. Our hosting providers recently upgraded our server to 4.0.16. ( I know it's old).. however after the upgrade my script is not working please find my error message below.. please can someone help?
Connecting to MySQL...
Unhandled Exception: System.FormatException: Input string was not in a correct f
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffe
r& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo in
at MySql.Data.Common.DBVersion.Parse(String versionString)
at Daily_Report.Daily_Report.Main() in C:\scripts\daily\\Module1.vb:line 69