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

  • Zaki.Mohammed@Verizon.Com
  • Topic Author
  • Offline
  • User
  • User
More
1 year 3 months 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
1 year 3 months 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.140 seconds
Powered by Kunena Forum