I'm Trying to create a Linked Server to an OBDC System DSN as Data Source in a SQL server 2008 64bit.
I run this script:
EXEC master.dbo.sp_addlinkedserver @server = N'SISTEMAS', @srvproduct = 'SISTEMAS', @provider = 'MSDASQL', @datasrc = 'FOXODBC', @location = '', @provstr = '', @catalog = '' GO
Linked Server is created, but when I test the connection, it returns an error:
The OLE DB Provider 'MSDASQL' has not been registered
I search the books online and found this:
*To create a linked server to access an ODBC database when you are using an ODBC data source: Create a System data source on the computer on which SQL Server is installed. Execute sp_addlinkedserver to create the linked server, specifying MSDASQL or NULL as provider_name, and the name of an ODBC system data source as data_source.*
So, It's any way to register this provider to SQL2008..?