all groups > sql server odbc > june 2006 >
You're in the

sql server odbc

group:

Error when importing data from AS/400 - appeared after SP1



Error when importing data from AS/400 - appeared after SP1 dr
6/7/2006 12:00:00 AM
sql server odbc: I cannot transfer a list of tables from AS/400 to SQL 2005, in SQL Server
Import and Export Wizard.

This is what happends:

In SQL server Import and Export wizard, I choose IBM AS400 OLE DB Provider,
with Properties:

Data Source: (IP adress of my AS/400)
User name, password: (My username/password on AS/400)
Default Collection: (library on AS/400)

Then I choose destination database, and Next, it starts transfering list of
tables . After a few seconds I get this error:

'IBMDA400.DataSource.1' failed with no error message available, result code:
E_INVALIDARG (0x80070057)

Additional Information:
'IBMDA400.DataSource.1' failed with no error message available, result code:
E_INVALIDARG (0x80070057). (System.Data)


Error appeared shortly after installation of SP1, so I suspect of SP1
(although I am not yet sure) . Error happends always, nevermind the number
of tables in library.

This is important error for us because we cannot do transfer from AS400 at
all.



Re: Error when importing data from AS/400 - appeared after SP1 C Oconnor
7/13/2006 3:16:08 PM
I have gotten the same error and I was wondering if you had found an
answer to this problem?



AddThis Social Bookmark Button