May 8, 2012 at 7:40 pm
I'm having problems creating a linked server using Microsoft OLE DB Provider for ODBC as the driver. I am running SQL Server 2008 on Windows Server 2008 64 bit. When I try to create a data source in Windows, Microsoft OLE DB Provider for ODBC is not available to use in the Data Source Manager. I do have Microsoft OLE DB Provider for SQL, SQL Native, and Oracle drivers but no ODBC driver From everything I can find, it appears that Microsoft OLE DB Provider for ODBC was deprecated in Windows Server 2003. I downloaded the install file for Windows Server 2003 and could not install it on the Windows Server 2008. How can I create a new Microsoft OLE DB Provider for ODBC or generic ODBC data source to connect to BMC Remedy Mid Tier to retrieve data?
May 9, 2012 at 11:57 am
It was deprecated and left behind because the OLE DB provider for ODBC performed horribly and there was little support for it moving forward with the energy being dropped into the .NET area. I would recommend looking elsewhere, maybe SSIS, to get data into SQL Server. SSIS 2008 supports ADO.NET over ODBC as a Data Source, but not as a Destination. Support for ADO.NET to ODBC as a Data Destination was added in SSIS for SQL 2012 though.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply