April 28, 2003 at 3:46 am
I have 2 servers Win2000 standard edition sp3
And On the Each one Sql2000 sp3 standart edition
db1, db2
I added Linked server db2 to db1 and db1 to db2.
And use it for simple queries for example
Select top 1 * from db1.Dbname.dbo.table1
Select top 1 * from db2.Dbname.dbo.table2
I never had problem with this
But now statisticly each 10 query return error
OLE DB provider 'SQLOLEDB' reported an error. The provider
did not give any information about the error.
OLE DB error trace [OLE/DB
Provider 'SQLOLEDB' ::GetSchemaLock returned 0x80004005:
OLE DB provider SQLOLEDB supported the Schema Lock
interface, but returned0x80004005 for GetSchemaLock .].
OLE DB error trace [OLE/DB
Provider 'SQLOLEDB' ::CreateSession returned 0x80004005:
The provider did not give any information about the
error.].
or when i use storeproc
The operation could not be performed because the OLE DB
provider 'SQLOLEDB' was unable to begin a distributed
transaction. [SQLSTATE 42000] (Error 7391) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d01c].
[SQLSTATE 01000] (Error 7300)
What is a problem ?
pls help !
April 28, 2003 at 6:47 am
Can you check whether MSDTC server is started?
April 29, 2003 at 2:13 am
MSDTC started and running in the two sides
No errors in Event LOg
Haw can i manage MSDTC service ?
Or manage his LOG ?
April 29, 2003 at 7:34 am
Read this KB article to see how to resolve error 7391. http://support.microsoft.com/default.aspx?scid=kb;en-us;306212
You can start/stop MSDTC service from control panel --> services.
Edited by - Allen_Cui on 04/29/2003 07:35:36 AM
April 29, 2003 at 10:31 am
It dos not help me
I have web servers and db servers in the same network
and 90% of Linked Servers queries works
and 100% of ADOConnections of Web Servers
works. I don't see any problem with network
and SET XACT_ABORT ON not help me
But I decreased in 50% Linked server queries and now the problem it happen in 2% of case.
Is here an limit of MSDTC transactions ?
All of decreased queries moved to work with Dirrect ADO connection and works
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply