Saving and retrieving to/from MYSQL database. Help.

[Krakatioison]

Hi everyone,
can someone point me to download of an example for saving and retrieving
to/from MYSQL database.
Or did anyone of you tried this and could share your code with me.
I've got some data which needs to be put to mysql database using VB.NET and
I can't figure this out.
Thanks a lot.
K.

 

[Cor Ligthert]

Hi Krakatioison,

I am curious why you are not using MSDE, the next version SQL server Express
will be even very much improved?

Both have a 4Gb is that the problem?

Cor

 

[Krakatioison]

Cor,
I am not sure if I am getting it.
4GB database limit? Is that what you wanted to say? That could be a big of a
problem.
My databases right now are in mysql already and I am populating them using
PHP scripts. But I want to do this using VB.NET running in my systray. You
know, I am playing around with all this.
Thing is, I need someone to show me how to send and retrieve data from/to
mysql, so I can do this. I can't find the way of doing it.
k.

 

[Ken Tucker [MVP]]

Hi,

http://dev.mysql.com/tech-resources/articles/dotnet/

Ken
-----------------------------
Hi everyone,
can someone point me to download of an example for saving and retrieving
to/from MYSQL database.
Or did anyone of you tried this and could share your code with me.
I've got some data which needs to be put to mysql database using VB.NET and
I can't figure this out.
Thanks a lot.
K.

 

[Ken Tucker [MVP]]

Cor,

Why is using an open source database a problem? My web host uses
it.

Ken
-----------------
Hi Krakatioison,

I am curious why you are not using MSDE, the next version SQL server Express
will be even very much improved?

Both have a 4Gb is that the problem?

Cor

 

[Krakatioison]

Ken, thanks a lot, there is no example to download as I wished/hoped for,
but hopefully somehow I will manage to do this.
K.

 

[Cor Ligthert]

Hi Krakatioson,

A better newsgroup for this question is
Adonet
<
Web interface:
<http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsof
t.public.dotnet.framework.adonet>

Before your ask you question again there have first a look what is writen
already in this newsgroup about mySQL
http://tinyurl.com/5z99n

When you have the choise, use OLEDB.
http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps?

Cor

Cor,
I am not sure if I am getting it.
4GB database limit? Is that what you wanted to say? That could be a big of a
problem.
My databases right now are in mysql already and I am populating them using
PHP scripts. But I want to do this using VB.NET running in my systray. You
know, I am playing around with all this.
Thing is, I need someone to show me how to send and retrieve data from/to
mysql, so I can do this. I can't find the way of doing it.
k.

 

[Ken Tucker [MVP]]

http://dev.mysql.com/downloads/dotnet.html

Ken
-------------------
Ken, thanks a lot, there is no example to download as I wished/hoped for,
but hopefully somehow I will manage to do this.
K.

 

[Cor Ligthert]

Hi Ken,

Not any problem at all however we are here on a Microsoft newsgroup.
And I got the idea he was looking for a new database, would be not nice
pointing sombody on the new SQL Server Express I thought.

I hope you understand my sentense now?

Cor

 

[Ken Tucker [MVP]]

Ok

Ken
------------------
Hi Ken,

Not any problem at all however we are here on a Microsoft newsgroup.
And I got the idea he was looking for a new database, would be not nice
pointing sombody on the new SQL Server Express I thought.

I hope you understand my sentense now?

Cor

 

[Krakatioison]

Thanks
k.

http://dev.mysql.com/downloads/dotnet.html

Ken