Whether this (User Variables) Is Supported

Whether this (User Variables) Is Supported

Postby Suresh » Wed 03 Jul 2013 09:56

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
Suresh
 
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.
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL