WinBatch Technical Support Forum

Archived Boards => COM Automation and dotNet => Topic started by: stanl on July 30, 2014, 10:59:20 am

Title: Show All Providers for .udl on 64bit with 32bit Office
Post by: stanl on July 30, 2014, 10:59:20 am
I've used code like this a lot
Code: Winbatch

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.