Page 1 of 1
Whether this (User Variables) Is Supported
Posted: Wed 03 Jul 2013 09:56
by Suresh
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
Re: Whether this (User Variables) Is Supported
Posted: Wed 03 Jul 2013 16:40
by Shalex
Suresh wrote:Convert Zero Datetime=True
There is no need to use this option with dotConnect for MySQL:
http://forums.devart.com/viewtopic.php?f=2&t=21367.
Suresh wrote:Allow User Variables=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."
If this doesn't help, describe the case when you want to use the Allow User Variables option with dotConnect for MySQL.