Import from INFORMIX (Cannot get the supported data types)

Hi!

I'm trying to import data from an Informix Database to my SQL Server 2005 database with the import/export wizard.
I have an ODBC-connection that works, Access fetches data with no errors. From the wizard I can only choose to use the IBM Informix OLE DB Provider as datasource. As fare as I know the OLE DB Provider is using settings from the ODBC-driver?

In SQL Server 2000 there is a posibillity to choose Other(ODBC provider) as datasource which works against this database. Any ideas how i can use an ODBC-datasource?
If I try to use the IBM Informix OLE DB Provider I get an error message after the first step of the wizard:

Cannot get the supported data types from the database connection "Provider=Ifxoledbc;Password=;Persist Security Info=True;User ID=uid;Data Source=db@.server".

ADDITIONAL INFORMATION:

IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002). (System.Data)

Anyone have any experience with this problem? I can't find any information that will solve this, but I have seen several questions about this.

I would be very grateful for some help!

Best Regards

Hello

Did you ever find the solution to this problem? I'm having similar errors and don't know what if wrong.

Thanks

|||Hi!

I could not find any solution. I had to uninstall SQL server 2005 and use SQL server 2000.

I think the problem has something with the SQL 2005 server's ODBC support. I read in a forum that Microsoft spent their time on OLE-DB, and that the OLE-DB driver from Informix has some problems. But i gave up trying to figure it out.

I'm sorry!

Trond U|||

Thanks for the information. That really bites. This is a huge disappointment. I guess I will have to find a machine with SQL Server 2000 installed on it. I don't have the option of uninstalling my SQL Server 2005.

Thank you for getting back to me,

Matt