Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. Customers who are not licensees of Microsoft Visual Basic 6.0 nor Microsoft Visual Studio 6.0 but are using older versions of the two Common Controls.Customers who are Microsoft Visual Basic 6.0 and/or Microsoft Visual Studio 6.0 licensees.This package is provided under the terms of the End User License Agreement and is intended for the following customers: This package will not install these Common Controls if they do not already exist on the target system. That will give you a good start, and probably help a bunch and give you some ideas about how to refine your Google searches if you need more details.This package updates two Microsoft Visual Basic 6.0 Common Controls: mscomctl.ocx and comctl32.ocx to address the issues described in the KB articles noted in the Related Resources section on this page. Use this (with suitable changes to fit your situation, of course): ' mostly copied from the Help File 'Ĭonst ConnectionString = "provider = .4.0 data source = c:\working\db1.mdb" The only other thing you'll need to use the ADODB objects is the value for a Connection String. Advantages to this method are that it takes less memory than the ActiveX Data Object control, and you have more options as to when to open/close, update, etc.
Look for "Microsoft ActiveX Data Objects 2.8 Library" and "Microsoft ActiveX Data Objects Recordset 2.8 Library". It has all the basics.įor this method, you will have to set the appropriate references using the Project/References menu item. Go to that help topic and scroll down until you find the section entitled "ADO". Down about 15 lines, there's a section entitled "Establishing a Connection to a Database". Open the VB6 help, go to the Search tab and enter "ADODB".
If you want more control over your data (for instance, to use the same recordset on multiple forms or in some other background process), use the ADODB library.
Plop one onto your form and set the properties. If you just want to use an ActiveX control, go to the Project/Components menu item, and select "Microsoft ADO Data Control 6.0 (OLEDB)". There are several very good sections about it in the Help file.
0 kommentar(er)
