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
