Show All Providers for .udl on 64bit with 32bit Office

Started by stanl, July 30, 2014, 10:59:20 AM

Previous topic - Next topic

stanl

I've used code like this a lot

Code (WINBATCH) Select

cFile="c:\temp\test.udl"
FilePut("",cFile)


which creates a .udl file that when opened pops up the Provider Menu which permits creating and testing a connection string. As of Office 2007, the ACE Provider is used in place of the Jet Provider. However, on a 64-bit system with 32bit Office installed, a .udl will not show the Ace Provider.  However, this command will

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\temp\test.udl

I tried to execute it from WB's RunShell(), but appear to be having a syntax hemorrhage.