| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Kagan <akagan(at)leadingedgeadmin(dot)com> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Windows ODBC Driver configuration help |
| Date: | 2019-11-14 22:47:49 |
| Message-ID: | 17588.1573771669@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Andrew Kagan <akagan(at)leadingedgeadmin(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin M2301 | 2019-11-16 03:10:16 | 404 repo: not found libpq-dev pkg |
| Previous Message | Andrew Kagan | 2019-11-14 22:03:55 | Windows ODBC Driver configuration help |