Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB

[Darren...@carmax.com]

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...@carmax.com
804.747.0422 x3221
========================

[Plugge, Joe R.]

Have you run the required coledbp.sql script, provided in the CSDK, against the sysmaster database on the database server?

Hello,

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[Eric Rowell]

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

--
Eric B. Rowell

[Eric Rowell]

Forgot.  You get these from the CDSK install directorys not the server install. 

--
Eric B. Rowell

[Darren...@carmax.com]

Hey Joe, Thanks for the response.

Yes, I dropped the previous running doledbp.sql and ran the latest
coledbp.sql from each ver.

========================
Darren Jacobs
Sr Database Analyst
Darren...@carmax.com
804.747.0422 x3221
========================

"Plugge, Joe R."
<JRPl...@west.co
m> To
"Darren...@carmax.com"
06/05/2009 01:30 <Darren...@carmax.com>,
PM "inform...@iiug.org"
<inform...@iiug.org>
cc

Subject
RE: Trouble connecting from

Mircrosoft SSIS to Informix Using
OLEDB

Have you run the required coledbp.sql script, provided in the CSDK, against
the sysmaster database on the database server?

-----Original Message-----
From: informix-l...@iiug.org
[mailto:informix-l...@iiug.org] On Behalf Of
Darren...@carmax.com
Sent: Friday, June 05, 2009 12:24 PM
To: inform...@iiug.org
Subject: Trouble connecting from Mircrosoft SSIS to Informix Using OLEDB

[Darren...@carmax.com]

.Net didn't install. Atleast I don't see cdotnet.sql.

========================
Darren Jacobs
Sr Database Analyst
Darren...@carmax.com
804.747.0422 x3221
========================

Eric Rowell
<ero...@gmail.co
m> To
Darren...@carmax.com
06/05/2009 01:31 cc
PM inform...@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...@carmax.com> wrote:

Hello,

--
Eric B. Rowell

[Darren...@carmax.com]

Does anyone have a link to doc's on the OLEDB drivers?

[Rajesh Nair]

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 ?

[Fernando Nunes]

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...

[Darren...@carmax.com]

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...@carmax.com
804.747.0422 x3221
========================

Fernando Nunes
<domusonline@gmai
l.com> To
Sent by: inform...@iiug.org
informix-list-bou cc
nc...@iiug.org

Subject
Re: Trouble connecting from

06/05/2009 07:01 Mircrosoft SSIS to Informix Using
PM OLEDB

--
Fernando Nunes
Portugal