ADODB Example

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. _ADODB.au3 #Region - Constants and Variables Global $objConnection = ObjCreate("ADODB.Connection") Global

FYI. If working in a 64-bit (x64) environment and using Office x86 (32-bit) which is very common, be sure you specify NOT to compile 64-bit. Otherwise you may experience COM Errors "Provider cannot be found. It may not be installed properly." #Region #AutoIt3Wrapper_UseX64=N #EndRegionIf you do NOT have two Data Sources shortcuts in Control Panel --> Administrative Tools, I'd recommend doing the following: Rename Existing "Data Sources (ODBC)" to "Data Sources (ODBC) 64-bit (x64)".T