transferring data via odbc -
09-21-2004
, 03:23 PM
i am connecting to DB2 on an AS400 using ODBC. I am tranferring the data
using DTS import wizard to a local SQL Server 2000. I have used this so far
for hundreds of files and haven't had a problem. Now, one specific table on
the 400 is giving me a problem. Here is the error i get when I click on the
transform button after i select the table in the dts import wizard.
Error Source:Microsoft OLE DB Provider for ODBC Drivers
Error Description {IBM} client access express odbc driver (32 bit) DB2/400
SQL 0901 - Sql system error
Context: Error calling OpenRowset on the provider
any help is appreciated. |