Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-01 : 08:33:50
|
| Ziva writes "Hi,I'v creates an Oracle linked server by using 'Microsoft OLE DB Provider for ODBC Driver'.I tried to create a view in order to read data from oracle database.I used "SELECT * FROM OPENQUERY (LinkedServerName,'Select * From Customers') ClientsWhen I'm running the query its work and i can even see the dataWhen I'm trying to save the view the system thrown this error:ODBC ERROR:[Microsoft][ODBC SQL Server Drivers][SQL Server] The Operation could not be performed because the OLE DB Provider 'MSDASQL' was unabled to begin a distributed transactionAny idea?Regards,Ziva" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-01 : 08:46:47
|
| Make sure your Distributed Transaction Coordinator Service is running.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
problem with saving a view based on oracle linked server