I am trying to import data from Informix in SS2K5 but am having trouble
setting up a connection.
I am using the OLE DB connection object but when I try to use the connection
manager to connect to Informix I get a 'ClassFactory cannot supply requested
class' error.
I assume that the Informix OLE DB driver is broken somehow. Is this the
driver I should be using or should I use something else?

Just to clarify:
In Dev Studio when creating a SQL Server 2005 Integration Services project
drag an OLE DB Source object onto the Data Flow pane, then attempt to set a
new connection to an Informix database using the OLE DB Connection Manager.
Select Informix OLE DB Provider from the NAtive OLE DB tree. Enter the
database name and click Test Connection.
I then get an error saying "Test connection failed because of an error in
initializing provider. ClassFactory cannot supply requested class".


"John Mason" wrote:

Hi,
Do you try Informix Connect version 2.90 TC3?
It works for me.

Just to clarify:
In Dev Studio when creating a SQL Server 2005 Integration Services project
drag an OLE DB Source object onto the Data Flow pane, then attempt to set a
new connection to an Informix database using the OLE DB Connection Manager.
Select Informix OLE DB Provider from the NAtive OLE DB tree. Enter the
database name and click Test Connection.
I then get an error saying "Test connection failed because of an error in
initializing provider. ClassFactory cannot supply requested class".


"John Mason" wrote:

I'll try that thanks.

"Steffi" wrote:

I have installed the IBM Informix 3.90 drivers but to no avail.
I can, for example, select the driver when using an OLEDB source but when I
try to select the 'Name of the table or the view' I get a Loading... message
and then an error.
"Could not retrieve the table information...
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002)"

Any thoughts?

"Steffi" wrote:

hi,
Unfortunately, in my experiene, the only way to include INFORMIX is using
SQL Command or SQL Command from Varivable.
There's some warnings but u can ingore it.

".... Cannot retrieve the column code page info from the OLE DB provider.
If the component supports the "DefaultCodePage" property, the code page from
that property will be used. Change the value of the property if the current
string code page values are incorrect. If the component does not support
the property, the code page from the component's locale ID will be used."


"John Mason" <JohnMason (AT) discussions (DOT) microsoft.com>
I have installed the IBM Informix 3.90 drivers but to no avail.
I can, for example, select the driver when using an OLEDB source but when I
try to select the 'Name of the table or the view' I get a Loading... message
and then an error.
"Could not retrieve the table information...
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002)"

Any thoughts?

"Steffi" wrote: