Re: Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB
Posted in 2009
Topics: Installation, Setup & Upgrades, Server Administration
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