April 7, 2005 at 11:19 am
I have setup a linked server to a Progress database. I can see the tables and views thru Enterprise Manager in the Pub catalog which I configured when I look at the linked server setup. However, when i try to do a simple query against the data with the following command I get an error message that the method is not supported:
SELECT *
FROM LINKED_SERVER.Pub.TableName
I'm using the Merant 32-Bit driver to connect via ODBC to Progress. It's just odd to me that I can see the structures in Progress which makes me think I have the linked server set up correct but can never query the data. Has anyone elese encountered this problem?
April 7, 2005 at 11:23 am
have you tried to use it in a four part naming :
Select * from Linked_server.database.owner.object
What error are you actually getting?
April 7, 2005 at 12:55 pm
Thank you for responding. The error is:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Method is not supported by this provider.]
I'm not really sure who the owner of the object is. In SQL Server I typically use dbo in that context, but I'm not really sure what to use in the Progress database. In my DSN I have to specify a user and a password for the Merant ODBC connection. I was thinking that handled the owner issue for me but now I see that you are right and that the database object may have a different owner. Do you have any experience with typical ownership for Progress objects?
April 8, 2005 at 7:01 am
I don't have any experience with that. But you don't have to supply the owner. I have a link server that I Access like this :
Select * from LkServer...TableName.
Maybe you could try without specifying the owner... or even the db if the previous doesn't work.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply