IBM SDK

When connecting to an INFORMIX database with SQL Servers Linked Server tool, the ifxoledbc.dll (which is part of IBM's SDK) is used. Which version of IBM's SDK and the ifxoledbc.dll work with SQL Server 2005 and Informix Dynamic Server 7.3? I'm getting an the following error (confidential is the artificial name of my linked server):

Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "CONFIDENTIAL".

I'm using SQL SERVER 2005 and I'm trying to connect to a INFORMIX Dynamic Server 7.3 through a linked server.

Do I need an update with IBM's SDK or am I not set-up properly?

Thanks,

Matt

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

Thanks

sql

IBM SDK

When connecting to an INFORMIX database with SQL Servers Linked Server tool, the ifxoledbc.dll (which is part of IBM's SDK) is used. Which version of IBM's SDK and the ifxoledbc.dll work with SQL Server 2005 and Informix Dynamic Server 7.3? I'm getting an the following error (confidential is the artificial name of my linked server):

Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "CONFIDENTIAL".

I'm using SQL SERVER 2005 and I'm trying to connect to a INFORMIX Dynamic Server 7.3 through a linked server.

Do I need an update with IBM's SDK or am I not set-up properly?

Thanks,

Matt

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

Thanks

i want to convert sql stored procedures to dll

can anyone help me and excuse my terrible english. i want to convert sql stored procedures to dll.

If i got you correctly then I don't think you can do so (convert stored procedure to dll) - the stored procedures reside in your database as its objects. Perhaps a little detail with what you want to achieve actually would have been of more help.

sql