Dan560
asked on
Unhandled Exception: System.FormatException: Input string was not in a correct format.
Hi,
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...
server=83.x.x.x;user=x.x.x .x;databas e=swdata;p ort=5002;p assword=x. x.x.x
Unhandled Exception: System.FormatException: Input string was not in a correct f
ormat.
at System.Number.StringToNumb er(String str, NumberStyles options, NumberBuffe
r& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(S tring s, NumberStyles style, NumberFormatInfo in
fo)
at MySql.Data.Common.DBVersio n.Parse(St ring versionString)
at MySql.Data.MySqlClient.Nat iveDriver. Open()
at MySql.Data.MySqlClient.MyS qlPool.Get PooledConn ection()
at MySql.Data.MySqlClient.MyS qlPool.Get Connection ()
at MySql.Data.MySqlClient.MyS qlConnecti on.Open()
at Daily_Report.Daily_Report. Main() in C:\scripts\daily\\Module1. vb:line 69
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...
server=83.x.x.x;user=x.x.x
Unhandled Exception: System.FormatException: Input string was not in a correct f
ormat.
at System.Number.StringToNumb
r& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(S
fo)
at MySql.Data.Common.DBVersio
at MySql.Data.MySqlClient.Nat
at MySql.Data.MySqlClient.MyS
at MySql.Data.MySqlClient.MyS
at MySql.Data.MySqlClient.MyS
at Daily_Report.Daily_Report.
What is on line 69?
ASKER
DBconnection1.Open()
Can you show some more code? The connection string you showed above and surrounding code.
ASKER
please find the attached code.
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok apologies for posting in the wrong forum