I remember rebooting the box after I installed the Microsoft 64-bit ODBC driver. So, just try that, it might help.

Hi everybody,

FYI, Microsoft has released a 64-bit OLEDB Provider for ODBC recently. The URL for downloading the driver is:

http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en#Instructions

I have installed the driver on 64-bit Windows 2003 and...

Thanks to all. FYI, We heard from Microsoft that the 64 bit ODBC driver will be available starting Windows 2008 only.

Hi Jim,

Thanks for providing the detailed instructions. But are these instructions for SQL 2005 32 bit or 64 bit. Because I tried it on SQL 2005 64 bit and I...

Earlier in one of my projects I have tried calling external components succesfully using sp_OACreate and exposing its methods to communicate with the component. Please see if it is possible...

Instead of calling the notepad.exe directly, can you wrap that command in a .vbs file or .bat file and try calling it and see if that works?