Programming Forums > Application Development > Visual Basic

Logical1 · Apr 8th, 2008, 6:39 PM

Hello guys
I have worked for several years in VB 6 for desktop application development and in an entirely different environment with PHP and MySQL.
For reasons that are too complicated to list I like to work a new project with VB 6.0 and MySQL.

1. What is your experience? Any comments, suggestions ideas, etc?
2. I have searched my usual sources and can't find much info or samples for this combination. Any suggestions for tutorials, books, etc?
3. I know nothing about .NET would that offer better options for such an experiment?
Thanks a bunch in advnce
logical1

Infinite Recursion · Apr 9th, 2008, 8:12 AM

1.
For starters, you may want to consider migrating to VB .NET to take advantage of the .NET framework.

2.
Is one of your usual sources Google? For connecting to MySQL from VB6 look into this:
"Visual Basic 6 code for connecting to a MySQL database using the MySQL ODBC driver"
http://www.cgi-interactive-uk.com/vb...ect_mysql.html

3.
Doing this in .NET makes the entire process incredibly easy.

dr.p · Apr 9th, 2008, 8:31 AM

Hi, Logical1!

What IR said is right on. .Net makes it waaaaaaay easier.

I'd never bothered to use MySQL in VB, before, so I figured I'd give it a shot. It was actually really cool!

Here are the resources that I used. The one I think would be most useful is first -- provided you decide to use .Net. If you've never used databases in VB.Net, make sure you at least read page 3 of the first article.

VB.Net MySQL Tutorial
MySQL.com - Connector/Net Docs
MySQL.com - How to Load and Search MySQL Using VB.Net
MySQL.com - Storing Connection Strings (kind of a side topic)

Dev.MySQL.com also has articles for Connector/ODBC, if you go with VB6.

Logical1 · Apr 9th, 2008, 2:02 PM

Thanks a million to both of you.

Infinite Recursion · Apr 9th, 2008, 2:17 PM

Glad to help... btw, welcome to the forums!

Apr 8th, 2008, 6:39 PM	#1
Logical1 Programmer Join Date: Apr 2008 Posts: 41 Rep Power: 0	Working with VB6 and MySQL database Hello guys I have worked for several years in VB 6 for desktop application development and in an entirely different environment with PHP and MySQL. For reasons that are too complicated to list I like to work a new project with VB 6.0 and MySQL. 1. What is your experience? Any comments, suggestions ideas, etc? 2. I have searched my usual sources and can't find much info or samples for this combination. Any suggestions for tutorials, books, etc? 3. I know nothing about .NET would that offer better options for such an experiment? Thanks a bunch in advnce logical1

Apr 9th, 2008, 8:12 AM	#2
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,453 Rep Power: 7	Re: Working with VB6 and MySQL database 1. For starters, you may want to consider migrating to VB .NET to take advantage of the .NET framework. 2. Is one of your usual sources Google? For connecting to MySQL from VB6 look into this: "Visual Basic 6 code for connecting to a MySQL database using the MySQL ODBC driver" http://www.cgi-interactive-uk.com/vb...ect_mysql.html 3. Doing this in .NET makes the entire process incredibly easy. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Apr 9th, 2008, 8:31 AM	#3
dr.p Programmer Join Date: Feb 2006 Location: Ohio Posts: 93 Rep Power: 3	Re: Working with VB6 and MySQL database Hi, Logical1! What IR said is right on. .Net makes it waaaaaaay easier. I'd never bothered to use MySQL in VB, before, so I figured I'd give it a shot. It was actually really cool! Here are the resources that I used. The one I think would be most useful is first -- provided you decide to use .Net. If you've never used databases in VB.Net, make sure you at least read page 3 of the first article. VB.Net MySQL Tutorial MySQL.com - Connector/Net Docs MySQL.com - How to Load and Search MySQL Using VB.Net MySQL.com - Storing Connection Strings (kind of a side topic) Dev.MySQL.com also has articles for Connector/ODBC, if you go with VB6. __________________ Neeley.org

Apr 9th, 2008, 2:02 PM	#4
Logical1 Programmer Join Date: Apr 2008 Posts: 41 Rep Power: 0	Thank you Thanks a million to both of you. __________________ ^c^

Apr 9th, 2008, 2:17 PM	#5
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,453 Rep Power: 7	Re: Working with VB6 and MySQL database Glad to help... btw, welcome to the forums! __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Programming Forums > Application Development > Visual Basic

Working with VB6 and MySQL database