Solved

VB6 & MySQL

Posted on 2011-02-26
2
513 Views
Last Modified: 2012-05-11
Hi - I'm using some of my code from my program in VBA to transfer it to VB6.  Are the connections & mysql queries/updates, etc identical in VB6 or do I have to change them?

Thanks - Zack
0
Comment
Question by:zack4x4
2 Comments
 
LVL 5

Accepted Solution

by:
advfinance earned 500 total points
ID: 34989102
Assuming you've used ADO, everything is the same, although to make it easier, you can upgrade any db connections or recordsets to take advantage of the limited in VB6

So, any lines like
   Set rs = Createobject("ADODB.Recordset")

Could change to
    Dim rs As New ADODB.Recordset
0
 
LVL 4

Author Closing Comment

by:zack4x4
ID: 34989121
Thanks!!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question