Recent content by klar

Jason, Thanks for the quick reply. I tried changing my linked server definition using yours as a pattern, but the results were the same. I wonder if there is something else that needs to be checked? Ken

Irena, I've been unsuccessful in attempting to create a linked server, as you say you have done. I would greatly appreciate any assistance you would provide to point the way! I have created a datasource that connects with the Test button, and named that datasource in the linked server setup. I...

I am having a similar problem, but can't get the thing to connect at all. When I try to display tables (under Linked server in Enterprise Manager), it returns error message "Error 7739: OLE DB Provider 'MSDASQL' reported an error.... IDBInitialize::Initialize returned 0x80004005..." My linked...

I have a question rather than a solution...:rolleyes: I am trying to establish a linked server to access my Progress database from SQL Server 2000, but can't find any documentation on the Provider String to use. I have set up a datasource using the Merant 3.60 driver for version 9.1d, and tried...

I have a "simple" update I'm trying to do. The idea is to update a field in table A with the value in table B, where the two tables can be joined on a common field. Here is a sample from among many variations on the theme. update pub.citationmaster A set (a.cstatus) = (SELECT...

Can't do a correlated update I have a similar but simpler update I'm trying to do. The idea is to update a field in table A with the value in table B, where the two tables can be joined on a common field. Here is a sample from among many variations on the theme. update pub.citationmaster A set...