Hi All
I am facing a peculiar problem and havent found a reference to it on the net.
I am connecting to an oracle instance (ORATEST) using a linked server in
SQL2000.

I need to integrate an oracle application with my SQL 2000 database
application.

I have a table named Table_Employee in SQL2000.
I have created a linked server for oracle called ORATEST.
To link oracle tables with SQL2000 application i have created view in
SQL2000 with the same name of my table as give below.

Create View Table_Employee as
Select * from ORATEST..SCOTT.Employee

Everything works fine and I even get the data. The only problem is that when
I open a transaction on the SQL Server and read data from the Table_Employee
view it gives me the following error.

[Micorosoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB
Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b]

I know that it works fine without the tranasction but I have to open a
transaction in my software.
So can any one give me a suitable workaround for this...
Help will be highly appreciated!!! Thanks a lot in advance