SSMS ODBC Linked Server Issue
От | Dulanic |
---|---|
Тема | SSMS ODBC Linked Server Issue |
Дата | |
Msg-id | CAMiuOHUZt1sFV10ytMBGabHCf6qksb5LZ3ryKhktN_+FtkxW2Q@mail.gmail.com обсуждение исходный текст |
Ответы |
RE: SSMS ODBC Linked Server Issue
|
Список | pgsql-odbc |
Hello,
from public.addresses
')
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
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.
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:
These are my options in ODBC.
В списке pgsql-odbc по дате отправления: