I want to make a link to Informix server. Steps that I do are as bellow.
- on win2003 server with Mssql2005+sp1
- installed "IBM Informix Connect 2.9"
- Create systemDSN ODBC with name "InformixDB" and test connection ,ok
- Open management studio and open query with user sa, write bellow commands
================================================
exec sp_addlinkedserver @server= 'testserver' ,
@srvproduct= ''
, @provider= 'MSDASQL'
, @datasrc= 'InformixDB'
, @location= ''
, @provstr= ''
, @catalog= ''
go
EXEC sp_tables_ex servertest
GO
=================================================
and get error
-----------------
Server: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 13
OLE DB provider 'MSDASQL' reported an error. The provider did not give any
information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: The provider did not give any information about the
error.].
----------------
above configuration works on other computer in my office but noticeable
difference between them
Thanks
Tarvirdi