- Thank you received: 0
Encountering table read error in Postgresql 14.3 through sql server link server.
- Zaki.Mohammed@Verizon.Com
- Topic Author
- Offline
- User
-
Less
More
1 year 6 months ago #14684
by Zaki.Mohammed@Verizon.Com
Encountering table read error in Postgresql 14.3 through sql server link server. was created 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.
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.
- admin
- Offline
- Admin
-
Less
More
- Thank you received: 8
1 year 6 months ago #14689
by admin
Replied by admin on topic Encountering table read error in Postgresql 14.3 through sql server link server.
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.147 seconds