Teradata Driver 15 Issue in Microsoft Access

General

Teradata Driver 15 Issue in Microsoft Access

I am experiencing and issue running a query against Teradata database tables using an outer join in Microsoft Access.  The query works with a simple join but not an outer join.  We recently upgraded to Teradata 15.10 (upgraded drivers too).  I'm wondering if anyone has experienced this and how they were able to correct it. 

It is a very basic query:

Select T1.Field1

From T1 LEFT OUTER JOIN T2

ON T1.Field2 = T2.Field2

GROUP BY T1.Field1

Any thoughts/suggestions are greatly appreciated.

Thanks,

C McKeever

2 REPLIES
Junior Contributor

Re: Teradata Driver 15 Issue in Microsoft Access

Can you show your actual query?

Your Select is the same as SELECT DISTINCT Field1 From T1

And what do you mean by issue, error message, wrong result?


New Member

Re: Teradata Driver 15 Issue in Microsoft Access

I'm having the same issue

get error ODBC Call Failed  [Teradata] [ODBC Teradata Driver] [Teradata Database] '{'('7B'X) is not a valid Teradata SQL Token (#-3704)

when running the following from MS Access (its a 2002/2003 file format ... mdb)

It runs without issues as-is on SQL Assistant and from Access with using regular join - but the Left Join causes the error

SELECT MF_PRD_VIEWS_VDMT_VDR_MRCH.AP_DPT_ID, MF_PRD_VIEWS_AVXT_AP_VDR_XREF.VENDOR_MASTER_ID, MF_PRD_VIEWS_AVXT_AP_VDR_XREF.MSC_AP_VENDOR_NBR, MF_PRD_VIEWS_AVXT_AP_VDR_XREF.STATUS_CD
FROM MF_PRD_VIEWS_AVXT_AP_VDR_XREF LEFT JOIN MF_PRD_VIEWS_VDMT_VDR_MRCH ON MF_PRD_VIEWS_AVXT_AP_VDR_XREF.VENDOR_ID = MF_PRD_VIEWS_VDMT_VDR_MRCH.VENDOR_ID;

each table has about 12000 records... tho one has about 50 more than the other - hence the LEFT JOIN