Re: Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB

Does anyone have a link to doc's on the OLEDB drivers? ======================== Darren Jacobs Sr Database Analyst Darren_Jacobs@carmax.com 804.747.0422 x3221 ======================== Eric Rowell <erowell@gmail.co m> To Darren_Jacobs@carmax.com 06/05/2009 01:31 cc PM informix-list@iiug.org Subject Re: Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB Did you run the follow on the server? OLE: dbaccess sysmaster $INFORMIXDIR/etc/coledbp.sql Just to let you know for Dot Net .NET dbaccess sysmaster $INFORMIXDIR/etc/cdotnet.sql On Fri, Jun 5, 2009 at 1:23 PM, <Darren_Jacobs@carmax.com> wrote: IDS v10FC8 HPUX 11.23 w2k3 Server Iconnect 3.00 FC2 Hello, I have a developer attempting to connect to an Informix database through OLEDB from SQL Sever 2005 SSIS.  The following msg is being observed.  The following is also being encountered when attempting to create a SQL Server Linked Server connection using OLEDB. This issue is seen with the 32 bit csdk 3.50 on a w2k3 32 bit box as well. Any help/assistance would be greatly appreciated. Error text from SSIS pkg: Test connection failed because of an error in intializing provider.  No error message available, result code: DB_E_ERRORSOCCURRED(0x8004E21) Error text from Linked Server: An exception occured while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) The OLE DB provider "ifxoledbc" for linked server "<svrname>" reported an error. The provider did not give any info about the error. Cannot initialize the data source object of OLEDB provider "ifxoledbc" for linked server "<svrname>". (Microsoft SQL Server, Error:7399) ======================== Darren Jacobs Sr Database Analyst Darren_Jacobs@carmax.com 804.747.0422 x3221 ======================== _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list -- Eric B. Rowell