Connect ProgreSQL to SSMS via Linked Server
Posted: Thu 09 Nov 2017 05:54
Hello,
I have to connect to a progresSQL database and when I run a query like SELECT * FROM OPENQUERY(SEQTA, 'select * from public.student') it works, however when I run this query SELECT * FROM OPENQUERY(SEQTA, 'select * from studentplandetailStudentplanfield') I get the following error
OLE DB provider "MSDASQL" for linked server "SEQTA" returned message "[Devart][ODBC][PostgreSQL]relation "studentplandetailstudentplanfield" does not exist".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "SEQTA".
Now the table exists as I can use another ODBC driver and it works.
I have created a document with all of the settings https://www.dropbox.com/s/8gs0n365mxh8k ... .docx?dl=0
The other issue, which is not a show stopper, is when I run SELECT * FROM seqta.au_nsw_trinityac.[public].[student] I get this error
Msg 7422, Level 16, State 1, Line 4
OLE DB provider "MSDASQL" for linked server "seqta" returned an invalid index definition for table ""au_nsw_trinityac"."public"."student"".
I have spent all day trying to get this to work with no success.
Thanks
Michael
I have to connect to a progresSQL database and when I run a query like SELECT * FROM OPENQUERY(SEQTA, 'select * from public.student') it works, however when I run this query SELECT * FROM OPENQUERY(SEQTA, 'select * from studentplandetailStudentplanfield') I get the following error
OLE DB provider "MSDASQL" for linked server "SEQTA" returned message "[Devart][ODBC][PostgreSQL]relation "studentplandetailstudentplanfield" does not exist".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "SEQTA".
Now the table exists as I can use another ODBC driver and it works.
I have created a document with all of the settings https://www.dropbox.com/s/8gs0n365mxh8k ... .docx?dl=0
The other issue, which is not a show stopper, is when I run SELECT * FROM seqta.au_nsw_trinityac.[public].[student] I get this error
Msg 7422, Level 16, State 1, Line 4
OLE DB provider "MSDASQL" for linked server "seqta" returned an invalid index definition for table ""au_nsw_trinityac"."public"."student"".
I have spent all day trying to get this to work with no success.
Thanks
Michael