I have an ODBC link to DB2 Database. I can see the values of the DB2's
tables in Access but not in SQL Server DTS.
IN DTS, I connect the Source but when i want to see the values in the
Data transformation task, i have this message :

HResult of 0x90040e37 (-2147217865) returned. Erreur inattendue. Un
résultat d'erreur a été renvoyé sans message d'erreur.

Someone have a solution?

dchaumeil@yahoo.fr (David Chaumeil) wrote in message news:<89a69082.0307212321.7a291786@posting.google. com>...
> I have an ODBC link to DB2 Database. I can see the values of the DB2's
> tables in Access but not in SQL Server DTS.
> IN DTS, I connect the Source but when i want to see the values in the
> Data transformation task, i have this message :
>
> HResult of 0x90040e37 (-2147217865) returned. Erreur inattendue. Un
> résultat d'erreur a été renvoyé sans message d'erreur.
>
> Someone have a solution?


What version is your client access ?

I had the similar error message before with older version client
access and in the ODBC configuration, you need to check the setting of
those parameters.

Good Luck !