Sunday, February 26, 2012

Error "The OLE DB provider "MSDASQL" has not been registered." on SQL 2005 6

Hi,
I am trying to create a linked server from SQL server 2005 (64bit) to IB 7.5 database.

I installed the driver for IB on SQL box and created a System DNS (using
%SystemRoot%\SysWOW64\odbcad32.exe), tested the connection fine.

Now, on SQL Management Studio, created a linked server to use the System DSN,
sp_addlinkedserver 'MyLinkedSrv', ' ', 'MSDASQL', 'MySYSDNS' -- went fine.

Then ran the openquery,
select * from OPENQUERY(MyLinkedSrv, 'select * from services')

An error msg returned fro the openquery.
The OLE DB provider "MSDASQL" has not been registered.

What am I missing here? I tried with "Native SQL Client" instead MSDASQL but it returns me invaild parameters...


Any advice on this would be aprreciated.

Regards,
Sunny

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=396615&SiteID=1

HTH

No comments:

Post a Comment