Re: Windows ODBC Driver configuration help

Andrew Kagan <[email protected]> writes:
> Hi All: First time poster and PostgreSQL noob...trying to set up a linked server in SSMS (SQL Server 15.0.2000.5) using 64-bit PostgreSQL Unicode(x64) driver. The PostgreSQL server is 10.5. My access to the server is readonly.
> I configured the datasource and tested successfully, and am able to create the linked server in SSMS and drill down to the tables, but if I try a simple query, I receive the error:

> Msg 7356, Level 16, State 1, Line 2
> The OLE DB provider "MSDASQL" for linked server "[DSNname]" supplied inconsistent metadata for a column. The column "[colname]" (compile-time ordinal 3) of object ""[table]"."public"."[column]"" was reported to have a "DBCOLUMNFLAGS_ISLONG" of 128 at compile time and 0 at run time.

I agree that this might be an ODBC configuration issue.  I know next
to nil about ODBC, but the people who do know hang out in the pgsql-odbc
list, so you might try asking there.

			regards, tom lane