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 |
|
gavinjb
Starting Member
34 Posts |
 Posted - 2007-10-26 : 03:51:25
|
Hi,I am trying to create a View that pulls data from databases on 2 servers (1 SQL 2000 and 1 SQL 2005), but when I try and save the view I get the following error, I have checked and the query runs with no problems, does anyone have any ideas how I can fix this.ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.[Microsoft][ODBC SQL Server Driver][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.][Microsoft][ODBC SLQ Server Driver][SQL Server[OLE DB error trace [OLD/DB Provider 'SQLOLEDB' ITransactionJoi JoinTransaction returned 0x800400a]. Thanks,Gavin, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-26 : 04:13:35
|
I am a bit confused.Are you using ODBC or OLEDB or both?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
gavinjb
Starting Member
34 Posts |
Posted - 2007-10-26 : 04:27:40
|
| Hi,Sorry I forgot to add that info, I am connecting to the SQL 2005 server with a Linked Server Setup on the SQL 2000 Server using SQL Server OLE DB Provider.Note: Since posting this I have tried creating a view on SQL 2005 which queries 2000 and this saves with no problem, so it looks like to me a config issue on 2000, but I dont know where to look and I could be completly wrong on this.Thanks,Gavin, |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-26 : 04:38:31
|
Why is there then an ODBC error?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
gavinjb
Starting Member
34 Posts |
Posted - 2007-10-26 : 04:44:03
|
| I haven't got a clue, all I know is that when I created the Linked Server I selected the "Microsoft OLE DB Provider for SQL Server", maybe it is a message for both OLE DB and ODBC. |
|
|
|
|
|
|
|
|
Creating a Cross Server View