Testing a 32-bit .udl on a 64-bit Windows OS

Really just mirroring this blog post in case it's really gone for good (google cache still has it thankfully).

If you need to test a 32-bit ODBC datasource on a 64-bit version of Windows _and_ there's no native test function (i.e. you're using the Microsoft ODBC for Oracle driver which is 32-bit only and has no test button), you can still use a .udl file to assign the provider and datasource to test.  It just takes a little extra legwork.  Run this and all will be well:

C:\WINDOWS\SYSWOW64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\path\to\test.udl