VB with MySQL

[joebhoy]

anyone has a sample program with MySQL back-end? just want to learn with VB with MySQL..

[RhinoBull]

Welcome to Forums!

I think it would be beneficial if you check ADO sticky thread in Database forum - it ahs sample and tutorials.

[zeezee]

Welcome to the Forums


As long as you use some Database connectivity Method like ADO, DAO , RDO, you can connect to almost any kind of Data Base.

For mySQL, you need to use ODBC. There is an ODBC Connector for mySQL in their site. you can download that.

And for Connections String , check this site.

http://www.connectionstrings.com/

For more info, check the DB FAQs in FAQ section in the Forum

[Hack]

Welcome to the forums.

After you connect, the question becomes, what are you going to do next?

Do you have a database built?

[Campion]

You know what's even cooler? Connecting your VB app to your mySQL database via SSH!

Reading how it's done is boring, but actually having it work is easy!

[joebhoy]

Welcome to the Forums


As long as you use some Database connectivity Method like ADO, DAO , RDO, you can connect to almost any kind of Data Base.

For mySQL, you need to use ODBC. There is an ODBC Connector for mySQL in their site. you can download that.

And for Connections String , check this site.

http://www.connectionstrings.com/

For more info, check the DB FAQs in FAQ section in the Forum

thanx for this one.. this would surely helps.. this is for my thesis.. i had a lot of questions but im speechless for now.. hehehhe.. thanx again..

[joebhoy]

Welcome to the forums.

After you connect, the question becomes, what are you going to do next?

Do you have a database built?

i don't have yet the mySQL software.. can u provide me some links so that i can dowload it... i don't have any background with mySQL, only the Microsoft Access... just want to learn mySQL...

[zeezee]

Well, if you know basic SQL, you can use any data base that supports SQL.
If your a doing a research perhaps it would be easy to tell you exactly what you are researching to help you out.

As for Links, this is the MySQL site
http://www.mysql.com/
http://dev.mysql.com/downloads/

You will need to download the Comunity Server , which is free.

And this is the link for the ODBC connector

http://dev.mysql.com/downloads/connector/odbc/3.51.html

I still think that its better if you start something like the ADO tutorial in the forums DB FAQ

http://www.vbforums.com/showthread.php?t=337051

[joebhoy]

thanx a lot mate... i'll try... thanx for your helps...

[leinad31]

Depends on what the scope of your thesis is, but as much as possible use a non-server hosted database (eg. Access) so you won't have to deal with network and/or hosting related issues. And you probably won't be coding stored procedures (T-SQL, PL/SQL, etc) and triggers anyway to keep things simple so databases that don't support those will do.

Simply state in your thesis that database back-end can be upgraded later on (MySQL, Oracle, SQL Server, etc) and will just involve changes to connection string. For thesis, focus on functionality of front-end rather than details regarding back-end.

[joebhoy]

our professor need MySQL as our back-end... we already done with Access.. thanx BTW leinard31... are you from Manila? im from bohol...