brokenhope

I have vb.net 2005, and 2003. What im trying to do is connect and retrieve and update data on my mysql database on my server. (Im going to try to make a mmorpg). I dont know where to start though... ive searched google, only found vb help, nothing useful came up at all. So can someone please give me a place to start at or give me some code pieces to look at?

Silvanus

I found a number of hits when I googled vb.net mysql. Try it!

__________________
:wq

brokenhope

Thats exactly what I searched, the results were all pointless crap on making some vb application to run on your site. I found absoulutely nothing for making a program that connected to a mysql database, I said I already searched google...

Silvanus

How about this?

#4 on the list googling vb.net mysql.

__________________
:wq

brokenhope

Yea, I looked at that but I didnt think it would work...

You see im not using any microsoft sql products, which is what it looks like it wants me to download... Im running apache on my computer with php and mysql, and im trying to connect to the mysql database on my apache server. Am I just mistaken or will that not work?

Rory

There are about a trillion and one ways of connecting to a mysql database, each has its own advantages and whichever is best depends upon what you want to do:
1. Use the mysql protocol (basically sql+ basic telnet style tcp).
2. Use the ADO(+) interface and drivers compatible with .NET
3. Use any number of APIs packaged in linked DLLs, as COM objects, or .NET classes.
The official .NET interface is at http://dev.mysql.com/downloads/connector/net/1.0.html, however I'd recommend using 2 if you which to be able support multiple data sources (e.g. switch to postgresql).