Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_ado_rds thread: ocn.BeginTrans vs ocn.Execute("BEGIN TRAN")


Message #1 by Steve Carter <Steve.Carter@t...> on Wed, 31 Oct 2001 17:18:46 -0000
The code 



	ocn.BeginTrans 



Fails with 'Object or Provider is not capable of performing requested

operation', but



	ocn.Execute("BEGIN TRAN")



is fine.  Why's that then?  Does it mean that my BEGIN TRAN will get

secretly rolled back while I'm not looking?  Or is it something to do with

the way I've opened the connection ocn?  I open it with



  set oCn = new ADODB.Connection

  oCn.open strConnect



where strConnect starts "Provider=MS Remote.1;Data Source=xxxx;Remote

Server=http://nnn.nnn.nnn.nnn;Handler=MSDFMAP.Handler;Internet

Timeout=300000;Transact Updates=True"



and the entry in msdfmap.ini is 



Connect="Driver={SQL Server}; Server=xxxxxxx; Database=xxxxxxx; UID=xxxxxx;

PWD=xxxxxxx"




  Return to Index