| Warren Brunk 2006-10-24, 6:29 pm |
| It seems to me that you will have to use a different conncetor then OLEDB.
You are using nested transactions which isnt supported by OLEDB provider.
http://support.microsoft.com/defaul...;EN-US;Q316872&
Perhaps Try ODBC or .net.
thanks,
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"DjPesto" <dj@x.com> wrote in message
news:450fe4a3$0$2015
$ba620dc5@text.nova.planet.nl...
We have made a databaselink to another SQL-server database on a remote
server. We have made some views to that database. In Peoplesoft it is
possible to read the data from that remote database, but when we try to do
an update or insert into that remote database we end up with an error
message:
---------------------
SQL error. Stmt #: 908 Error Posistion: 0 Return: 8601 *[Mircosoft][ODBC SQL
Server Driver][SQL Server][OLE/DB provider returned message: Cannot start
more transactions on this session.]
*[Mircosoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB
Provider 'SQLOLEDB' ItransactionalLocal:
:StartTrans
---------------------
When we execute the insert statement in SQL Analyser the statement is
executed with no errors??
Anyone having any ideas on the this?
--
Met vriendelijke groet
Douwe Miedema
|