Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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";
connectionString = "Data Source=" + server + ";" + "DATABASE=" +
database + ";" + "UID=" + uid + ";" + "Pwd=" + password + ";";
connection = new MySqlConnection(connectionString);
Anyone knows how I can solve this?
Could I use the Umbraco API somehow?
which version of MySql you used?
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.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted