Post reply

Accessing data from Progress Linked Server

  • April 7, 2005 at 11:23 am

    #551243

    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

    #551279

    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

    #551455

    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 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply