Home All Groups Group Topic Archive Search About
Author
21 Dec 2008 8:36 PM
Kid
Hi

Is there some good MySQL database sample use C# or VC or MFC ?

Is there some good api or library that I can access MySQL without MySQL ODBC
driver ?

Thank for your grand help.

Author
21 Dec 2008 9:17 PM
Arne Vajhøj
Kid wrote:
> Is there some good MySQL database sample use C# or VC or MFC ?
>
> Is there some good api or library that I can access MySQL without MySQL ODBC
>  driver ?

For .NET usage download and install MySQL Connector for .NET - it comes
with docs, but you don't need the docs - it works just like all other
ADO.NET providers - the class names just start with MySql.

For C/C++ you will need to pick between several API's. I will
suggest the standard MySQL C API. It is very simple to use and
if you have used MySQL from PHP then you have a good start.

Arne
Are all your drivers up to date? click for free checkup

Author
21 Dec 2008 10:10 PM
Alec S.
"Kid" <K**@discussions.microsoft.com> wrote:
> Is there some good MySQL database sample use C# or VC or MFC ?
>
> Is there some good api or library that I can access MySQL without MySQL ODBC
>  driver ?


See if your local library has any books on (My)SQL. I learned to write apps that
interface with MySQL using the sample programs in a couple of those. “MySQL :
the complete reference” by Vikram Vaswani was particularly useful.


--
Alec S.
news/alec->synetech/cjb/net
Author
22 Dec 2008 12:13 AM
Mark Rae [MVP]
"Kid" <K**@discussions.microsoft.com> wrote in message
news:4A055D8B-856F-4E05-A84C-45E13C00DF28@microsoft.com...

> Is there some good api or library that I can access MySQL without MySQL
> ODBC
> driver ?

http://forums.mysql.com/read.php?3,233976,233976

As Arne said, this works (essentially) in exactly the same way as the SQL
Server .NET native data provider...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Author
22 Dec 2008 1:49 AM
Arne Vajhøj
Mark Rae [MVP] wrote:
> "Kid" <K**@discussions.microsoft.com> wrote in message
> news:4A055D8B-856F-4E05-A84C-45E13C00DF28@microsoft.com...
>> Is there some good api or library that I can access MySQL without
>> MySQL ODBC
>> driver ?
>
> http://forums.mysql.com/read.php?3,233976,233976
>
> As Arne said, this works (essentially) in exactly the same way as the
> SQL Server .NET native data provider...

Or Oracle or DB2 or PostgreSQL or FireBird or ...

When starting using parameters then one should note that
parameters are marked ?xxx not @xxx with MySQL and that
obviously also the data types enumeration is slightly
different.

And if one uses DbProviderFactory and IDb* interfaces
as one is supposed to do then there are no code changes
at all.

Arne

Bookmark and Share