- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- pemission error with linked server
pemission error with linked server
- BullCreek
- Topic Author
- Visitor
-
11 years 6 months ago #872
by BullCreek
pemission error with linked server was created by BullCreek
I've set up the linked server using the SQL script provided here and when I click on the Test button it works, but when I run a query or try to browse the Tables/View, I get some variation of:
The OLE DB provider "PGNP" for linked server "SHADOWDB" reported an error. Access denied. Cannot obtain the require interface ("IID_IDBSchemaRowset") from OLE DB provider "PGNP" for linked server "SHADOWDB".
MSSQL 2005
Postgres 8.3
Hope someone can help. Also, what is the difference between Developer and Business license - I am a developer and need to JOIN against a few tables in one Postgres database occasionally and a linked server would certainly make it easy.
The OLE DB provider "PGNP" for linked server "SHADOWDB" reported an error. Access denied. Cannot obtain the require interface ("IID_IDBSchemaRowset") from OLE DB provider "PGNP" for linked server "SHADOWDB".
MSSQL 2005
Postgres 8.3
Hope someone can help. Also, what is the difference between Developer and Business license - I am a developer and need to JOIN against a few tables in one Postgres database occasionally and a linked server would certainly make it easy.
Please Log in or Create an account to join the conversation.
- BullCreek
- Topic Author
- Visitor
-
11 years 6 months ago #873
by BullCreek
Replied by BullCreek on topic Re: pemission error with linked server
FWIW, when I run the following query:
select * from openquery(SHADOWDB, 'select * from meta_bgnumberblock');
I get a different error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "PGNP" for linked server "SHADOWDB" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "PGNP" for linked server "SHADOWDB".
select * from openquery(SHADOWDB, 'select * from meta_bgnumberblock');
I get a different error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "PGNP" for linked server "SHADOWDB" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "PGNP" for linked server "SHADOWDB".
Please Log in or Create an account to join the conversation.
11 years 6 months ago #874
by Moderator
Replied by Moderator on topic Re: pemission error with linked server
Please make sure that "Allow inprocess" parameter is checked in PGNP Provider Properties.
Please Log in or Create an account to join the conversation.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- pemission error with linked server
Time to create page: 0.061 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- pemission error with linked server