Heterogeneous Services problem with read-only SQL Server

From: CMcphe6584 <cmcphe6584_at_aol.com>
Date: 08 Aug 2002 19:50:53 GMT
Message-ID: <20020808155053.12235.00002191@mb-fj.aol.com>

Hi,

Im running Heterogeneous Services under version 8.1.7, trying to extract data from an SQL Server 6.5 database.

Unfortunately, the whole instance of SQL server is in Read-Only mode; when I try do something like

use <database>
select count(*) from table

from within dbms_hs_passthrough, I get an error saying that an attempt was made to run a START transaction in a read-only database.

If I logon, I do indeed get the same error on the SQL server if I type in start transaction.

Has anybody out there seen any workarounds for this.

Cheers,

Colin McPherson Received on Thu Aug 08 2002 - 14:50:53 CDT