Whether this (User Variables) Is Supported

Whether this (User Variables) Is Supported

Postby Suresh » Wed 03 Jul 2013 09:56

In Connection String "server=;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
Posts: 1
Joined: Wed 03 Jul 2013 09:29

Re: Whether this (User Variables) Is Supported

Postby Shalex » Wed 03 Jul 2013 16:40

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/docs/?parameters.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.
Devart Team
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for MySQL