Browse by Tags

FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

Published 19 August 7 4:40 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle...

Filed under: sql server, replication, kba, service pack2, oracle, linked, publisher

FIX: Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005: "Transaction manager has cancelled the distributed transaction"

Published 9 July 7 3:55 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you commit a distributed...

Filed under: sql server, server, kba, transaction, linked

FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used

Published 27 June 7 11:52 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error messages when you run a query against...

Filed under: sql server, server, query, kba, table, linked, alias