Whether this (User Variables) Is Supported

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Suresh
Posts: 1
Joined: Wed 03 Jul 2013 09:29

Whether this (User Variables) Is Supported

Post by 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

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Re: Whether this (User Variables) Is Supported

Post by 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/ ... 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.

Post Reply