arithmetic operation resulted in an overflow when connecting to mysql db - API Questions

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Fredrik Esseen 610 posts 906 karma points

May 13, 2013 @ 16:35
0

Arithmetic operation resulted in an overflow when connecting to MySql-DB
Hi!

Im trying to connect to a MySQL-db to save some data but get "Arithmetic operation resulted in an overflow".

The Umbraco installation is on an mssql-express but i need to save some data to an old mysql-db.

Im using Umbraco 6.0.5.

I read about problems with the mysql connector and tried downgrading the one that umbraco uses but got other problems so I switched back.
```
string server = "server.server.com";
                string database = "database";
                string uid = "uid";
                string password = "password";
                string connectionString;
                connectionString = "Data Source=" + server + ";" + "DATABASE=" +
                database + ";" + "UID=" + uid + ";" + "Pwd=" + password + ";";

                            MySqlConnection connection;
                            connection = new MySqlConnection(connectionString);
                            connection.Open();
```
Anyone knows how I can solve this?

Could I use the Umbraco API somehow?
Copy Link
Owen 123 posts 246 karma points

Jun 05, 2013 @ 13:38

0

which version of MySql you used?

Copy Link
Owen 123 posts 246 karma points

Jun 05, 2013 @ 14:15

0

It's a known issue by MySql connector, Umbraco use MySql connector 6.6.x since 6.0.0, and as MySql connector 6.6 dropping support for old style password authentication.

What you need to do is create a new user using newer authentication.

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?

Arithmetic operation resulted in an overflow when connecting to MySql-DB