I have been trying to configure data direct connect 4.2 to work with UDB 8.1 on AIX, both installed locally.
When I run the demoodbc application to test the connection, I get the following error:-

./demoodbc: will connect to data source 'DB2 Wire Protocol' as user '*****/*****'.
......SQLExecute has Failed. RC=-1
MSG = [DataDirect][ODBC 20101 driver][DB2]1504

I cant find an SQLSTATE of 60, I am unsure as to what the -805 error is (is this the SQLCODE?)
Also, Im stuck with the [DB2]1504 message.

Does anyone know what any of this means?