Hi!
I'm using UniDirect .NET driver to work with databases. I create a constructor using the UniCommandBuilder:
Dim uniDirectConstructor as new corelab.UniDirect.UniCommandBuilder(uniDirectDataAdapter)
I need to set QuotePrefix and QuoteSuffix properties because dataset contains tables which names have spaces and some special characters. I have no problem with Sql Server:
constructorComandoUni.QuotePrefix = "["
constructorComandoUni.QuoteSuffix = "]"
With MySQL I use the same code (only changing the quote):
constructorComandoUni.QuotePrefix = "`"
constructorComandoUni.QuoteSuffix = "`"
When executing these last both instructions the problem comes. The execution throw an exception showing this message:
"No se puede encontrar el método CoreLab.MySql.MySqlCommandBuilder.QuotePrefix."
In english->
"Mehod can not be found: CoreLab.MySql.MySqlCommandBuilder.QuotePrefix."
That means unidirect have not implemented this method for MySQL? Is it only implemented for SqlServer? What is the matter?
Thanks in advance for your attention,
Faithfully,
Jordi Yevenes
Clarity Systems S.L.
UniDirect problem with MySQL
question...
Thanks, I'm going to try this solution dowloading MySQLDirect .NET 2.70. Anyway we bought Unidirect .NET driver last year so if the problem is solved with MySQLDirect .NET 2.70 could I use it as unlimited version or I need an unidirect driver update?
It doesn't work
Hi,
I've trying using MySQLDirect .NET 2.70. I have set QuotePrefix and QuoteSuffix to "`" to fix the problem about table names with spaces and special characters but it doesn't work.
It returns me an exception because it's not using prefixes correctly.
example:
Insert command on Access (QuotePrefix and Quotesuffix = "[/]"):
Insert Into [Table A]( [User Id], [User Name])
Insert command on MySQL (QuotePrefix and Quotesuffix = "`":
Insert Into Table A( User Id, User Name)
As you could see, it doesn't use prefixes to delimit table names and it causes an exception.
Maybe I'm not doing correctly. Do you have any idea?
Thanks
I've trying using MySQLDirect .NET 2.70. I have set QuotePrefix and QuoteSuffix to "`" to fix the problem about table names with spaces and special characters but it doesn't work.
It returns me an exception because it's not using prefixes correctly.
example:
Insert command on Access (QuotePrefix and Quotesuffix = "[/]"):
Insert Into [Table A]( [User Id], [User Name])
Insert command on MySQL (QuotePrefix and Quotesuffix = "`":
Insert Into Table A( User Id, User Name)
As you could see, it doesn't use prefixes to delimit table names and it causes an exception.
Maybe I'm not doing correctly. Do you have any idea?
Thanks
The problem still remains...
Sorry I'm posting the same message but I would like to know something more about the problem. Could I fix it?
I've trying using MySQLDirect .NET 2.70. I have set QuotePrefix and QuoteSuffix to "`" to fix the problem about table names with spaces and special characters but it doesn't work.
It returns me an exception because it's not using prefixes correctly.
example:
Insert command on Access (QuotePrefix and Quotesuffix = "[/]"):
Insert Into [Table A]( [User Id], [User Name])
Insert command on MySQL (QuotePrefix and Quotesuffix = "`"):
Insert Into Table A( User Id, User Name)
As you could see, it doesn't use prefixes to delimit table names and it causes an exception.
Maybe I'm not doing correctly. Do you have any idea?
Thanks
I've trying using MySQLDirect .NET 2.70. I have set QuotePrefix and QuoteSuffix to "`" to fix the problem about table names with spaces and special characters but it doesn't work.
It returns me an exception because it's not using prefixes correctly.
example:
Insert command on Access (QuotePrefix and Quotesuffix = "[/]"):
Insert Into [Table A]( [User Id], [User Name])
Insert command on MySQL (QuotePrefix and Quotesuffix = "`"):
Insert Into Table A( User Id, User Name)
As you could see, it doesn't use prefixes to delimit table names and it causes an exception.
Maybe I'm not doing correctly. Do you have any idea?
Thanks