Not sure if it will help, but have you tried SQL Server Profiler?
>The ODBC driver is definitely truncating, but I don't know why... From SQL.LOG:
>
>
>SWORD 1
>PTR 0x01C31853 [ 31] "special, department, category\ 0\ 0"
>SQLLEN 31
>SQLLEN * 0x0012F4B0 (41)
>
>DIAG [01004] [Microsoft][ODBC SQL Server Driver]String data, right truncation (0)
Chris McCandless
Red Sky Software