ADO

Using Excel VBA to Copy an ADODB Recordset to Multiple Worksheets

by
Microsoft VBA logo

In adding functionality to an ancient Excel VBA reporting app for an Oracle database, I decided to set up a temporary worksheet to use as a place to store data before copying it to multiple other worksheets rather than copying directly from the recordset multiple times. Basically, this VBA procedure takes an ADODB recordset and … Read more

ADODB Issues in VB.NET with an Oracle Database

by
Oracle Database logo

During my recent VB6 to VB.NET Forms upgrade adventure, I had to wade through quite a bit of code that, while still functional, should be upgraded further when time permits.  Most of this code is used for data access, and being that it was written back in the VB6 / Classic ASP days, Active Data … Read more