Author Topic: Show All Providers for .udl on 64bit with 32bit Office  (Read 3170 times)

stanl

  • Pundit
  • *****
  • Posts: 1812
Show All Providers for .udl on 64bit with 32bit Office
« on: July 30, 2014, 10:59:20 am »
I've used code like this a lot
 
Code: Winbatch
 
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.