Re: Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB

Are you sure your security permissions are not causing issues ? Have you checked your linked server properties for security ? Also can you post your connection string attributes being used ? On Fri, Jun 5, 2009 at 12: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 >