{"action":"closed","issue":{"url":"https://api.github.com/repos/schotime/NPoco/issues/191","labels_url":"https://api.github.com/repos/schotime/NPoco/issues/191/labels{/name}","comments_url":"https://api.github.com/repos/schotime/NPoco/issues/191/comments","events_url":"https://api.github.com/repos/schotime/NPoco/issues/191/events","html_url":"https://github.com/schotime/NPoco/issues/191","id":102480539,"number":191,"title":"MySql Provider: Format of the initialization string does not conform to specification starting at index 0","user":{"login":"EliotJones","id":7862346,"avatar_url":"https://avatars.githubusercontent.com/u/7862346?v=3","gravatar_id":"","url":"https://api.github.com/users/EliotJones","html_url":"https://github.com/EliotJones","followers_url":"https://api.github.com/users/EliotJones/followers","following_url":"https://api.github.com/users/EliotJones/following{/other_user}","gists_url":"https://api.github.com/users/EliotJones/gists{/gist_id}","starred_url":"https://api.github.com/users/EliotJones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EliotJones/subscriptions","organizations_url":"https://api.github.com/users/EliotJones/orgs","repos_url":"https://api.github.com/users/EliotJones/repos","events_url":"https://api.github.com/users/EliotJones/events{/privacy}","received_events_url":"https://api.github.com/users/EliotJones/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-21T23:37:03Z","updated_at":"2015-08-22T09:45:33Z","closed_at":"2015-08-22T09:45:33Z","body":"I'm trying to get up and running with NPoco using the following packages:\r\n\r\n    <packages>\r\n      <package id=\"MySql.Data\" version=\"6.9.7\" targetFramework=\"net46\" />\r\n      <package id=\"NPoco\" version=\"2.10.9\" targetFramework=\"net46\" />\r\n    </packages>\r\n\r\nMy connection string is as follows:\r\n\r\n    <connectionStrings>\r\n     <add name=\"Default\" connectionString=\"Server=localhost;Uid=uglytoad;Pwd=password;Database=database-develop\" />\r\n    </connectionStrings>\r\n\r\nThis connection string works when querying using normal the MySqlCommand but not using NPoco:\r\n\r\n        using (var db = new Database(\"Default\", DatabaseType.MySQL))\r\n        {\r\n            var connstring = ConfigurationManager.ConnectionStrings[\"Default\"].ConnectionString;\r\n            var con = new MySqlConnection(connstring);\r\n            con.Open();\r\n                \r\n            var a = new MySqlCommand(\"SELECT * FROM country\", con);\r\n            var r = a.ExecuteReader();\r\n            while (r.Read())\r\n            {\r\n                var e = r.GetInt32(0);\r\n            }\r\n\r\n            var myCount = db.Execute(\"SELECT COUNT(*) FROM country\");\r\n            return myCount;\r\n        }\r\n\r\nI get the error in the title on the second to last line, it also fails using ```db.Fetch<Country>```:\r\n\r\nAn exception of type 'System.ArgumentException' occurred in NPoco.dll but was not handled in user code\r\nFormat of the initialization string does not conform to specification starting at index 0\r\n\r\nThe Data providers in my config are:\r\n\r\n    <system.data>\r\n      <DbProviderFactories>\r\n        <add name=\"MySQL.Data.MySqlClient\" \r\n             invariant=\"MySql.Data.MySqlClient\" \r\n             description=\".Net Framework Data Provider for MySQL\" \r\n             type=\"MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\" />\r\n      </DbProviderFactories>\r\n    </system.data>\r\n\r\nI'm sure I'm missing something simple but can't find any documentation for getting set-up with MySql. Any ideas?"}}