Logical1

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

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."

dr.p

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

Logical1

Thanks a million to both of you.

__________________
^c^

Infinite Recursion

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."

Steel9561

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?

humm... I am also very experienced in Visual Basic 6 desktop applications but mostly connecting to Access databases. I have also wondered how to connect to MySQL Databases with VB6 and the only thing I was able to find out is that there is an ODBC connector that you actually install on the machine that lets you connect to MySQL Databases. I was able to do it once but only for local databases. I never got to be able to connect to remote databases.

2. I have searched my usual sources and can't find much info or samples for this combination. Any suggestions for tutorials, books, etc?

I can just give you the address where you can download the ODBC connector, I think that should give you a good start:

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

3. I know nothing about .NET would that offer better options for such an experiment?
Thanks a bunch in advnce
logical1

I assume yes, check out this addresses:

http://www.vbmysql.com/articles/vbne...utorial-part-1
http://dev.mysql.com/tech-resources/...ng-vb-net.html

__________________
Opening you the door to success in the best freelance website: Rent a Coder