I want to export data from SQL Server 2000 to DB2/400 via Client Access ODBC driver (32 bit). I did it with the basic steps in SQL Server, but it doesn't work and I received an error message regarding the SQL provider.
If you exported the scripts to create the databases on DB2/400 from your SQL Server 2000 and ran them to create the databases on DB2 Universal for iSeries, there may be some naming convention problems if the field names or data types are not fully supported on the iSeries. I would suggest you check the tables created by your scripts on the iSeries system and verify the table names, field names and data types. This is most likely where you will find the answer.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.