Re: Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB

Forgot. You get these from the CDSK install directorys not the server install. On Fri, Jun 5, 2009 at 1:31 PM, Eric Rowell <erowell@gmail.com> wrote: > 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 > -- Eric B. Rowell