I have a sql server that has a linked server set up which is an Oracle
database. I can start the process of creating a SQL view of the needed data
in the Oracle database as follows:
SELECT * FROM OPENQUERY(cadtelbase, 'select * from cadtel_data_724.E356_S0
where ATTR964 = ''V01-03-00108''') If I execute the view I get the expected
results, but as soon as I try to save the view I receive the following SQL
Server Enterprise Manager error message.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation
could not be performed because the OLE DB provider â'OraOLEDB.Oracleâ' was
unable to begin a distributed transaction. [Microsoft][ODBC SQL Server
Driver][SQL Server][OLE/DB provider returned message: New transaction cannot
enlist in the specified transaction coordinator. ] [Micorsoft][ODBC SQL
Server Driver][SQL Server][OLE DB error trace [OLE/DB Provider
â'OraOLEDB.Oracleâ' ITransactionJoi JoinTransaction returned 0x8004d00a].
Any help on this would greatly be appreciated.
Thanks!
JackieNever mind. I found the solution. Simply can not create the view using
Enterprise Manager view designer, must create the view using query analyzer!
"Wishing I was skiing mom" wrote:
> I have a sql server that has a linked server set up which is an Oracle
> database. I can start the process of creating a SQL view of the needed data
> in the Oracle database as follows:
> SELECT * FROM OPENQUERY(cadtelbase, 'select * from cadtel_data_724.E356_S0
> where ATTR964 = ''V01-03-00108''') If I execute the view I get the expected
> results, but as soon as I try to save the view I receive the following SQL
> Server Enterprise Manager error message.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation
> could not be performed because the OLE DB provider â'OraOLEDB.Oracleâ' was
> unable to begin a distributed transaction. [Microsoft][ODBC SQL Server
> Driver][SQL Server][OLE/DB provider returned message: New transaction cannot
> enlist in the specified transaction coordinator. ] [Micorsoft][ODBC SQL
> Server Driver][SQL Server][OLE DB error trace [OLE/DB Provider
> â'OraOLEDB.Oracleâ' ITransactionJoi JoinTransaction returned 0x8004d00a].
> Any help on this would greatly be appreciated.
> Thanks!
> Jackie
>
No comments:
Post a Comment