I use ODBC Driver for PostgreSQL as a linked server in Microsoft SQL Server 2014 (64 bit)
I use construction like that:
Code: Select all
insert openquery(PG_DB,'select "value","order" from "delme"')
select [value],[order] from [delme]
OLE DB provider "MSDASQL" for linked server "PG_DB" returned message "[Devart][ODBC][PostgreSQL]syntax error at or near "ORDER"".
when i rename the column in the postgresql table as uppercase i.e.
Code: Select all
insert openquery(PG_DB,'select "value","ORDER" from "delme"')
select [value],[order] from [delme]
I have seen viewtopic.php?f=55&t=35069 but this is something different, i'm afraid, and select * from "delme" doesn't work either.
Nevertheless, yours driver is great for mssql! Much better than the stock one.