Encountering table read error in Postgresql 14.3 through sql server link server.

More
9 months 3 weeks ago #14684 by Zaki.Mohammed@Verizon.Com
We are not able to fetch the data through a link server call  from sql server 2017 to postgresql 14.3
We are using the PGNP Server driver 1.4.0.3563

Please see the attached image.
below is the text of the error.
OLE DB provider "PGNP" for linked server "PGSQL_smartreferral_new14" returned message "ERROR:  column d.adsrc does not exist
LINE 1: ...attlen AS FIELD_LENGTH, A.atttypmod AS FIELD_MOD, D.adsrc AS...
                                                             ^
".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "PGNP" for linked server "PGSQL_smartreferral_new14". The provider supports the interface, but returns a failure code when it is used.
 
Attachments:

Please Log in or Create an account to join the conversation.

More
9 months 2 weeks ago #14689 by admin
Please upgrade the PGNP Provider to build 3662, or later, in order to connect to Postgres 14.3.

Please Log in or Create an account to join the conversation.

Time to create page: 0.137 seconds
Powered by Kunena Forum