UniDirect problem with MySQL

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
guiz
Posts: 11
Joined: Wed 09 Mar 2005 08:54
Location: Barcelona (SPAIN)

UniDirect problem with MySQL

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

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Fri 11 Mar 2005 14:43

Try to test this problem with MySQLDirect .NET 2.70.

guiz
Posts: 11
Joined: Wed 09 Mar 2005 08:54
Location: Barcelona (SPAIN)

question...

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

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

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

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Wed 20 Apr 2005 08:11

We have fixed this problem for the UniDirect .NET.
Look forward for the next build.

Post Reply