syntax error at or near "{" at character 86(#-1)

[SoloCup]

I am in Access 2003. Connecting using the PostgeSQL ODBC driver. I am linking the tables from an SQL database. My queries work fine if I use the default
table join "...where the joined fields from both tables are equal." If I change the join to "..use all records from one and the records from the other where they match" I get an "ODBC call failed message,syntax error at or near "{" at character 86(#-1). "

I have the tracking turned on and it shows a different statement SQL statement created
in Access than is being actually sent to SQL.
___________________________________________________________


What Access shows in the SQL box:

SELECT
items.item, mfg_vendors.vendor
FROM
items LEFT JOIN mfg_vendors ON items.vendor = mfg_vendors.vendor;


What Access actually sends to the ODBC driver:

SELECT
"items"."item","mfg_vendors"."vendor"
FROM
{oj "items" LEFT OUTER JOIN "mfg_vendors" ON ("items"."vendor" =
"mfg_vendors"."vendor" ) }
___________________________________________________________

Note the "{oj" that was added to the version that was sent to the ODBC.
That seems to be the problem. The Jet driver seems to be in there at about
this point in the communication, but I can't see where any settings would change this issue. I have verified that I have a current version of the Jet engine.

Any other thoughts?

Thanks

Jim

 

[PHV]

Does the PostgeSQL ODBC driver support outer joins ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SoloCup]

Yes it does. We have tested it outside of Access.