VB.net Discussion

dont worry about it guys! worked on it this weekend with a friend, got some results, i am going to have it done in a few days if i am not too busy with work, thanks again!
 
http://www.vbmysql.com/articles/vb_mysql_t...rial-part1.html
http://www.vbmysql.com/articles/vb_mysql_t...rial-part2.html
http://www.vbmysql.com/articles/vb_mysql_t...rial-part3.html
http://www.vbmysql.com/articles/vb_mysql_t...rial-part4.html

The above tutorials demonstrate how to use MySql with VB.net. It is fairly simple to follow along with. Even I was able to write my own example and get it to compile. I was planning on using MySQL along with VB.net to write a new NetCallerID application. It seems that HomeSeer may be using a Database to store all their information in the new HS 2.0. So i have put my application on hold until i figure out what is going on with them. If they are using some other database then it would be more benificial for me to use the same type of database they are using.

If I find that there is no need to use the same database as HomeSeer then i will resort back to MySQL databases and combine them with PHP web pages to create a simple Caller ID interface. I would then like to run my application as a service and simply use a web interface to query and manipulate the database as needed.
 
Is this a utility class with functions for talking to mySQL or are you still just using the standard System.Data.OleDb class functions?

Has mySQL started supporting stored procedures yet?
 
Hey pat,

Have not seen you arround for a while. This is what MySQL is calling a connector. Their official name for it is Connector/NET. It is a open source class originally written and published on ByteFX. The people at MySQL liked it so much that they actually hired the author to work for them. So this is a MySQL supported class which can be directly compiled with your .net solution or it can be referenced as a dll.

http://www.vbmysql.com/articles/vb_mysql_t...art3.html#part6

Here is the site link to download the Connector
http://dev.mysql.com/downloads/connector/net/1.0.html

The Connector has a serious lack of documentation available online. It does come with a decent help file but many parts of the help file are MIA. Mike the author of the above tutorials is an expert at mysql with vb.net I forget what is relationship is with the Connector but i know it was an important one. I think his four tutorials are the only ones available as of now.

They are fairly simple to follow so it may be a good idea just to work through them really fast so that you can have one more tool under your belt while developing with vb.net

It only took me a few hours to work though the tutorials.
 
Back
Top