Pass-Through Query using ODA Returns Blank Dates

kayodeok

Member
I need to construct a Pass-Through Query using ODA to pull data from JDE into Access.

I have the ODBC Connection String as:

ODBC;CONVERTCURRENCY=Y;CONVERTJULIANDATES=;CONVERTUDC=Y;ConvertFun=1;DISPLAYOPTIONS=0;DSN=ODA-Pass-Thru;DateTimeFun=1fffff;ENVIRONMENT=PD7334;LONGCOLUMNNAMES=N;LONGTABLENAMES=N;NumericFun=12ff69;SHIFTDECIMALS=;StringFun=57e7d;SystemFun=0;;

This connection string was derived from Table F0911 (by looking at the Properties) but when I try to create a Pass-Through Query based on this Table, the content of the date fields all turn out blank, in addition, some other fields such as GLU, GLLNID, GLOPSQ all have weird characters in their field names.

I have the Pass-Through Query as:

SELECT * FROM F0911

(this was meant to be a simple test before I write more queries)

I have configured my ODA Connection to "Convert User Defined Codes" and "Convert Currency Values" but I note that the ODBC Connection String above shows:

CONVERTJULIANDATES=;

I changed this to:

CONVERTJULIANDATES=Y;

and re-run the query but there was no difference to the outcome.

Could someone help?

Regards

Kayode Okeyode
 
Back
Top