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) 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.