Missing SQL OLE DB Providers?

 

Just came across an issue on installing Litespeed from Quest https://www.quest.com/litespeed-for-sql-server/ on a Windows 2003 64 Bit environment . Litespeed in fact requires Microsoft OLE DB Provider for SQL Server, and after some troubleshooting we've figured out that we've had the registry corrupted and by re-registering our sqloledb.dll everything worked out fine.

 

Faruk Celik (https://blogs.msdn.com/farukcelik),  a Microsoft Support Engineer from lovely and sunny Instanbul :-), has been very helpful here, and talking once again about blogs not to miss, I highly recommend you a couple of posts that he wrote to troubleshoot OLE DB Providers issues though UDL:

 

Basics first : "UDL Test"

https://blogs.msdn.com/farukcelik/archive/2007/12/31/basics-first-udl-test.aspx

 

“UDL Test” on a 64 bit machine

https://blogs.msdn.com/farukcelik/archive/2007/12/31/udl-test-on-a-64-bit-machine.aspx

 

Therefore: if you have a 64 bit environment and you cannot see the provider you're looking for when performing your basic test with UDL BUT your 32 provider test on your 64 machine works out fine, it might be that you have to re-register your 64bit sqloledb.dll via:

 

regsvr32 "C:\Program Files\Common Files\System\Ole DB\sqloledb.dll"

 

- Beatrice Nicolini -