Could not start a transaction for OLE DB provider 'SQLOLEDB'. 
Author Message
 Could not start a transaction for OLE DB provider 'SQLOLEDB'.
Hi,

Hope somebody can help.  I'm trying to replicate from sql server 2000 to sql
7.0 replicating transactions.  I intermittenlty get this error: Could not
start a transaction for OLE DB provider 'SQLOLEDB'.  Can anybody help?

John




Sat, 28 Feb 2004 18:35:45 GMT
 Could not start a transaction for OLE DB provider 'SQLOLEDB'.

This is because of network problems. I think you are using immediate
updating subscribers, yes?

I hope so anyway, because I was and I saw the same problem you did. The
subscriber, when it is an immediate updating one, uses 2PC (MSDTC) to
communicate back to the publisher. MSDTC requires a name resolver to resolve
the host name of the publisher to an IP address. If your network doesn't
have such a resolver, or if you cannot ping the publisher from the
subscriber by host name, you need to fix that problem. Best way to do that
is probably to add an entry into the HOST file, or better still configure a
DNS server.

Hope this helps
Adrian


Quote:
> Hi,

> Hope somebody can help.  I'm trying to replicate from sql server 2000 to
sql
> 7.0 replicating transactions.  I intermittenlty get this error: Could not
> start a transaction for OLE DB provider 'SQLOLEDB'.  Can anybody help?

> John





Wed, 10 Mar 2004 03:13:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Msg 7392 Could not start a transaction for OLE DB provider 'SQLOLEDB'

2. msg 7392 - Could not start a transaction for OLE DB provider 'SQLOLEDB'

3. OpenQuery using OLE DB provider 'SQLOLEDB'

4. It's not ODBC - It's not ASP - It's OLE/DB

5. OLE DB provider 'SQLOLEDB' does not contain table 'mytable'

6. Why OLE DB provider 'SQLOLEDB' doesn't support distributed transactions?

7. Error 7399: OLE DB provider 'MSDASQL'

8. OLE DB provider 'STREAM' error

9. Microsoft's OLE DB Simple Provider 1.5 Library isn't cutting it :(

10. Could not start a transaction for OLE DB provider 'MSDAORA'.

11. Error 7302: Could Not Create instance of OLE DB Provider 'SQLOLEDB'.

12. Error 7302: Could Not Create Instalnce of OLE DB Provider 'SQLOLEDB'


 
Powered by phpBB® Forum Software