ADODB Example

12 posts in this topic

spudw2k 163

Man, seems like I've been waiting for days for the site to come back up so I could post this.I'm putting together a Scan Engine tool that collects system info (via WMI, Reg, etc...). It will collectively store the data on either a SQL server, or local MDB. Here's a simple UDF I made to handle the ADODB stuff. I'll share the rest (Scan Engine Builder) when it's ready.

I added the ability to create JET DB Files (.MDB) so it is a bit more useful for demo purposes.

Added Where Clause to Example

Sooner or later I'll modify the GetTablesAndColumns to translate the field types into the literal data types (text,int,date,etc...) and make a more meaningful demo (Multiple tables and what ever else I can think of or someone recommends).