?
Solved

VB6 & MySQL

Posted on 2011-02-26
2
Medium Priority
?
523 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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses

840 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