Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
2 posts • Page 1 of 1
In Connection String "server=192.168.1.20;User Id=root;password=root;port=3306;database=admin_tysovicoreadmintool;Connect Timeout=30;Allow User Variables=True;Convert Zero Datetime=True" its not accepting User Variables and Zero Datetime=True willit support this feature by defult
There is no need to use this option with dotConnect for MySQL: http://forums.devart.com/viewtopic.php?f=2&t=21367.Suresh wrote:Convert Zero Datetime=True
Please refer to http://www.devart.com/dotconnect/mysql/ ... eters.html: "MySQL server variables are also denoted using '@' symbol. When encountered in query text, such fragments are treated as parameters only if they are found in MySqlCommand.Parameters collection; otherwise they are considered server variables."Suresh wrote:Allow User Variables=True
If this doesn't help, describe the case when you want to use the Allow User Variables option with dotConnect for MySQL.