i wan't to transfer data from sql server 2000 to as400 -
db2/sql. i have made all necessary things like creating of
table in as400-db2 with same attributes and same field
names. i have reached upto positon where while executing
transfer all the fields are being checked and then the
transfer starts but it prompts the error "sql0804 error,
sqlda not valid" and the transfer gets cancelled i am
using dsn to transfer data into as400 ie client access
ODBC driver(32bit)

please help in getting thru .

This error AFAIK is coming from your DB2 client

Make sure the mappings between source datatypes and destination are
compatible. Also check the settings on your Driver

http://www.fh-sbg.ac.at/~ulamec/sql/sqlda.htm



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"ravindra joshi" <ravindra.joshi (AT) intentia-india (DOT) com> wrote