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 608 posts 904 karma points
    May 13, 2013 @ 16:35
    Fredrik Esseen
    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?

  • Owen 123 posts 246 karma points
    Jun 05, 2013 @ 13:38
    Owen
    0

    which version of MySql you used?

  • Owen 123 posts 246 karma points
    Jun 05, 2013 @ 14:15
    Owen
    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.

Please Sign in or register to post replies

Write your reply to:

Draft