Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB
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 ========================
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 > ======================== > Shot in the dark... Try putting CLIENT_LOCALE and DB_LOCALE in the connection string. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Good Morning, Here's the resolution for solving our connectivity issue w/OLEDB: We set CLIENT_LOCALE=en_US.CP1252 and DB_LOCALE=en_US.819 Informix Tech support assisted with the resolution - PMR 10512,487,000 for those interested. Thanks again to all who responded! ======================== Darren Jacobs Sr Database Analyst Darren_Jacobs@carmax.com 804.747.0422 x3221 ======================== Fernando Nunes <domusonline@gmai l.com> To Sent by: informix-list@iiug.org informix-list-bou cc nces@iiug.org Subject Re: Trouble connecting from 06/05/2009 07:01 Mircrosoft SSIS to Informix Using PM OLEDB 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 > ======================== > Shot in the dark... Try putting CLIENT_LOCALE and DB_LOCALE in the connection string. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list