MIME-Version: 1.0
From: Dulanic <dulanic@gmail.com>
Date: Tue, 17 Aug 2021 13:36:01 -0500
Message-ID: 
 <CAMiuOHUZt1sFV10ytMBGabHCf6qksb5LZ3ryKhktN_+FtkxW2Q@mail.gmail.com>
Subject: SSMS ODBC Linked Server Issue
To: pgsql-odbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000006a0cb05c9c59933"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMiuOHUZt1sFV10ytMBGabHCf6qksb5LZ3ryKhktN_%2BFtkxW2Q%40mail.gmail.com>
Precedence: bulk

--00000000000006a0cb05c9c59933
Content-Type: text/plain; charset="UTF-8"

Hello,

I have reviewed a few different examples of SQL Server/Postgres ODBC linked
server connections. I have gotten some to work, but some tables refuse.
This is the query I am attempting to run and the methods I have tried so
far.

select *
from POSTGRES.teslamate.[public].addresses

and

 select * from openquery(POSTGRES,'
select *
from public.addresses
')

but both error out /w this error:

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "POSTGRES" supplied
inconsistent metadata for a column. The column "display_name" (compile-time
ordinal 2) of object "
select *
from public.addresses
" was reported to have a "LENGTH" of 512 at compile time and 174 at run
time. It seems like it is saying it's a 512 length field, and it is. It is
a character varying(512). However, when the query runs, it comes back
saying it's a 174 length field which is the current max length. These are
the settings I am using for ODBC, though I have tried every
possible variation of these that I could find to solve.

These are my options in SSMS:
https://dulanic.com/img/ssms.png

These are my options in ODBC.
https://dulanic.com/img/odbc.png
https://dulanic.com/img/odbc1.png
https://dulanic.com/img/odbc2.png

--00000000000006a0cb05c9c59933
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>I have reviewed a few different =
examples of SQL Server/Postgres ODBC linked server connections. I have gott=
en some to work, but some tables refuse. This is the query I am attempting =
to run and the methods I have tried so far.</div><div><br></div><div>select=
 *<br>from POSTGRES.teslamate.[public].addresses<br></div><div><br></div><d=
iv>and</div><div><br></div><div>=C2=A0select * from openquery(POSTGRES,&#39=
;</div>select *<br>from public.addresses<br>&#39;)<div><br></div><div>but b=
oth error out /w this error:</div><div><br></div><div>Msg 7356, Level 16, S=
tate 1, Line 1<br>The OLE DB provider &quot;MSDASQL&quot; for linked server=
 &quot;POSTGRES&quot; supplied inconsistent metadata for a column. The colu=
mn &quot;display_name&quot; (compile-time ordinal 2) of object &quot;<br>se=
lect *<br>from public.addresses<br>&quot; was reported to have a &quot;LENG=
TH&quot; of 512 at compile time and 174 at run time. It seems like it is sa=
ying it&#39;s a 512 length field, and it is. It is a=C2=A0character varying=
(512). However, when the query runs, it comes back saying it&#39;s a 174 le=
ngth field which is the current max length. These are the settings=C2=A0I a=
m using for ODBC, though I have tried every possible=C2=A0variation of thes=
e that I could find to solve.<br></div><div><br></div><div>These are my opt=
ions in SSMS:</div><div><a href=3D"https://dulanic.com/img/ssms.png">https:=
//dulanic.com/img/ssms.png</a><br></div><div><br></div><div>These are my op=
tions in ODBC.</div><div><a href=3D"https://dulanic.com/img/odbc.png">https=
://dulanic.com/img/odbc.png</a><br></div><div><a href=3D"https://dulanic.co=
m/img/odbc1.png">https://dulanic.com/img/odbc1.png</a><br></div><div><a hre=
f=3D"https://dulanic.com/img/odbc2.png">https://dulanic.com/img/odbc2.png</=
a><br></div><div><br></div><div><br></div><div><br></div><div><br></div><di=
v><br></div></div>

--00000000000006a0cb05c9c59933--