SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:08 AM
| ||||
| ||||
 Creating a view from a linked server Hi i have created a new database and a new linked server that points to an AccessDB using an ODBC DSN. Now inside that new sql db i have create i need to created a new view so i open EM went to views and paste the following select * from openquery (AccessLinkedServer,'select * from mytable') i press run and i see the data ok .but when i try to save the view i get the following ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: [DataDirect][ODBC dBase driver]Optional feature not implemented.] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoi JoinTransaction returned 0x8004d00a]. *** Sent via Developersdex http://www.developersdex.com ***      |
|
02-29-2008, 07:11 AM
| ||||
| ||||
| Re: Creating a view from a linked server tolisss (nospam@devdex.com) writes: > i have created a new database and a new linked server that points to an > AccessDB using an ODBC DSN. > Now inside that new sql db i have create i need to created a new view so > i open EM went to views and paste the following > > select * from openquery (AccessLinkedServer,'select * from mytable') > > i press run and i see the data ok .but when i try to save the view i get > the following > > ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation > could not be performed because the OLE DB provider 'MSDASQL' was unable > to begin a distributed transaction. Try creating the view from Query Analyzer. I seem to recall that when you create a view from Enterprise Manager, it starts a transaction. Later when you come to create the view itself, the OLE DB provider cannot upgrade the transaction to a distributed one. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
 |
« Modifing the row that invokes a trigger from within that trigger
|
VB.NET Web Programmer in New York $40/hr »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 07:54 AM.
