MySql Connector for CF 2.0...

[cmsmith81]

Am I correct here...?? MySql has released version 5.1 of their connector which works with the Compact Framework 2.0???

From their website: (see #2) (http://dev.mysql.com/downloads/connector/net/5.1.html)

Connector/Net 5.1 is the most exciting release of MySQL's fully managed ADO.Net provider to date. Some of the most user-requested features have been included. For example:

1. Support for fully commented stored procedures. 
*!*!*!*!2. Support for Compact Framework 2.0. 
3. Support for ASP.Net 2.0 Membership and Role systems.

Does this mean that we can now write Pocket PC programs to transact data with MySql servers? I downloaded and installed it and added references to the mysql.data.cf.dll and mysql.data.tests.cf.dll librarires.

I can not get it to work!! Am I correct that this connector allows pocket pcs to transact with MySql Servers? I will post the error information that I am getting in a few minutes, but I just want to make sure that I am understanding version 5.1 correctly (that it works with the CF). I can find NO documentation, nor ANY discussion about support for the CF with MySql.

Any information will be greatly appreciated!!

Thanks,
Corey

[cmsmith81]

The answer to my above question is YES! and I think I may have it working now... I'll update this when I know.

[TheDawgLives]

Did you get it working in the Data Source Designer? Every time I try to create a MySQL data source, I get this message:
"The new connection uses a data provider that is not supported"

I tried adding a reference to MySql.Data.CF.dll but still no joy.

[cmsmith81]

I have the same problem. I beleive that you can not use it with the datasource designer. I got it to work with code only and also with the design-time UI controls. I hope they integrate it with the datasource designer sometime, but I'm just happy they finally released a version compatible with .Net CF! It does everything I need it to do; it just may save some time in future projects to be able to use the datasource designer.

If you need any help to get it working with code, let me know.

-Corey

[cmsmith81]

I have the same problem. I beleive that you can not use it with the datasource designer. I got it to work with code only and also with the design-time UI controls. I hope they integrate it with the datasource designer sometime, but I'm just happy they finally released a version compatible with .Net CF! It does everything I need it to do; it just may save some time in future projects to be able to use the datasource designer.

If you need any help to get it working with code, let me know.

-Corey

[cmsmith81]

I have the same problem. I beleive that you can not use it with the datasource designer. I got it to work with code only and also with the design-time UI controls. I hope they integrate it with the datasource designer sometime, but I'm just happy they finally released a version compatible with .Net CF! It does everything I need it to do; it just may save some time in future projects to be able to use the datasource designer.

If you need any help to get it working with code, let me know.

-Corey

[cmsmith81]

sorry for the tripple post here, I'm at the airport with a poor connection... I hit the post reply button several times because it was not responding

[TheDawgLives]

I have the same problem. I beleive that you can not use it with the datasource designer. I got it to work with code only and also with the design-time UI controls. I hope they integrate it with the datasource designer sometime, but I'm just happy they finally released a version compatible with .Net CF! It does everything I need it to do; it just may save some time in future projects to be able to use the datasource designer.

If you need any help to get it working with code, let me know.

-Corey

The weird thing is that the MySQL data source designer works just fine for regular (non CF) programs. I guess they just didn't compile the data source designer code into the CF drivers?