UniDirect problem with MySQL

UniDirect problem with MySQL

Postby guiz » 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.
guiz
 
Posts: 11
Joined: Wed 09 Mar 2005 08:54
Location: Barcelona (SPAIN)

Postby Oleg » Fri 11 Mar 2005 14:43

Try to test this problem with MySQLDirect .NET 2.70.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56

question...

Postby guiz » Wed 23 Mar 2005 14:27

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?
guiz
 
Posts: 11
Joined: Wed 09 Mar 2005 08:54
Location: Barcelona (SPAIN)

It doesn't work

Postby guiz » Thu 31 Mar 2005 08:34

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
guiz
 
Posts: 11
Joined: Wed 09 Mar 2005 08:54
Location: Barcelona (SPAIN)

The problem still remains...

Postby guiz » Fri 15 Apr 2005 06:53

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
guiz
 
Posts: 11
Joined: Wed 09 Mar 2005 08:54
Location: Barcelona (SPAIN)

Postby Oleg » Wed 20 Apr 2005 08:11

We have fixed this problem for the UniDirect .NET.
Look forward for the next build.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect Universal