UniDirect problem with MySQL
Posted: Wed 09 Mar 2005 09:30
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.
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.