“Arithmetic operation resulted in an overflow” error upon MySQLConnection.Open()

[EDN Admin]

<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
Setup:
<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
Windows 7 SP1 64 bit Visual Studio 2012 MySQL .Net Connector 6.6.4
<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
I have a vb .net WinForm app which connects to a MySQL server using the MySQL .Net Connector. It was working perfectly. I then formatted the pc, reinstalled the same version of windows as before, but I installed a slightly newer version of the MySQL .Net Connector,
as well as Visual Studio 2012 instead of 2010.
<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
Now, when the code where I open the connection executes, i.e.:
<pre class="lang-sql prettyprint prettyprinted" style="padding:5px; border:0px; font-size:14px; vertical-align:baseline; background-color:#eeeeee; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; width:auto; max-height:600px <code style="margin:0px; padding:0px; border:0px; font-size:14px; vertical-align:baseline; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif <span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Dim mySQLcon <span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b As<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent New MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlConnection<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 (<span class="str" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#800000 "SERVER=www.tadirect.co.za;DATABASE=tadirq_db1;UID=********;PASSWORD=********;"<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 )<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
mySQLcon<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b Open<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()[/code][/code]
<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
At the mySQLcon.Open() line I get the following exception:
<pre class="lang-sql prettyprint prettyprinted" style="padding:5px; border:0px; font-size:14px; vertical-align:baseline; background-color:#eeeeee; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; width:auto; max-height:600px <code style="margin:0px; padding:0px; border:0px; font-size:14px; vertical-align:baseline; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif <span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent System<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent OverflowException<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 :<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Arithmetic operation resulted <span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b in<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent an overflow at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Authentication<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlAuthenticationPlugin<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent HandleAuthChange<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 (<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlPacket packet<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 )<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Authentication<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlAuthenticationPlugin<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Authenticate<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 (<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Boolean reset<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 )<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent NativeDriver<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Authenticate<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 (<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent String authMethod<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ,<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Boolean reset<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 )<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent NativeDriver<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b Open<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Driver<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b Open<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Driver<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b Create<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 (<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlConnectionStringBuilder settings<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 )<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlPool<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent GetPooledConnection<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlPool<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent TryToGetDriver<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlPool<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent GetConnection<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at MySql<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Data<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlClient<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent MySqlConnection<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="kwd" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#00008b Open<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 ()<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent
at TAD_Automator<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent modWebsite<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 .<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent UpdateMySQLDatabase_Cases<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 (<span class="pln" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent Boolean bSilent<span class="pun" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:#000000 )}[/code][/code]
<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
I have tried changing the build from Any CPU to 32 bit as well as 64 bit but it made no difference...
<p style="padding-right:0px; font-size:14px; vertical-align:baseline; clear:both; word-wrap:break-word; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif
Any ideas? It used to work before I reinstalled Windows/VS/MySQL... <hr class="sig Fabricio Rodriguez Pretoria, South Africa

View the full article