Monthly Archives: July 2014

ADODB Connection string for LocalDB and SQL Server Native Client

The limit on Access MDB file size is 2GB. To get around that I wanted to try out the lightweight LocalDB server, rather than SQLExpress. SqlLocalDB.msi is 38MB sqlncli.msi is 3MB for win32, 5MB for win64 It took a while … Continue reading

Posted in Excel/VBA | Tagged , , , , , , , | Leave a comment

VBScript to list installed OLEDB Providers

I found that the script I got by googling for that title failed on the line: CreateObject(“RegEdit.Server”) Error: ActiveX component can’t create object: ‘RegEdit.Server’ So here’s my own VBScript : ‘List of installed OLEDB providers on local computer Option Explicit … Continue reading

Posted in Productivity | Tagged , , , , , | 2 Comments