A former colleague of mine wrote a VB application that imports data into a MYSQL server.
The script has worked fine for a good number of years. However the MYSQL server was recently upgraded to version 4.0.16 (old I know) and now my script does not work.
Our server is managed by our hosting provider and unfortunately I do not have any management access.
The error message I get when running the script is -
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:\Users\scripts\daily\Module1.vb:line 69
Line 69 shows - DBconnection1.Open()
Can anyone help me with this issue? I am afraid to say I have no VB writing knowledge and would really appreciate some help.