Monthly Archives: Jul 2014

ADODB Connection string for LocalDB and SQL Server Native Client

Posted on Jul 11, 2014 by Patrick O'Beirne, Excel/VBA developer

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 , , , , , , , | 3 Comments

VBScript to list installed OLEDB Providers

Posted on Jul 11, 2014 by Patrick O'Beirne, Excel/VBA developer

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 , , , , , | 4 Comments