p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_discuss thread: Error No such interface supported


Message #1 by "Thang Nguyen" <thangnh_1999@y...> on Sat, 4 Jan 2003 04:02:19
Hi , I wrote a sample code about Transaction in ASP and AccessXP but when 
run below code  ,
Web browser appear message : <font color="red">No such interface 
supported</font>
Can you help me to solve this prolem?

*OS WIN2K
*IIS 5
*Database AccessXP

Error:No such interface supportedTransaction Abort

<%@ Transaction= Required %>
<%
  On Error Resume Next
  Dim objConn, objRS
   DBPath = Server.MapPath("bookstoredb.mdb")
   myDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" 
   myDSN = myDSN & DBPath & ";"
   query = "Select * from books where item_id= " & 6
   Set objConn = Server.CreateObject("ADODB.Connection")
   objConn.Open myDSN 
   If err.Number <> 0 Then
     Response.Write "Error:" & err.Description 
     ObjectContext.SetAbort
     Response.End
   else 
     Set objRS = objConn.execute(query)
     Do while not objRS.EOF
       Response.Write "<br>"
       For Each objField in obj.fields 
         Response.Write objField.value
       Next 
       objRS.MoveNext
       Response.Write "<br>"
     Loop  
     ObjectContext.SetComplete
   End If
   objConn.Close
   Set objConn = nothing
   
   Sub OnTranactionCommit()
     Response.WRite "Transaction Commit" 
   End Sub  
   
   Sub OnTransactionAbort()
     Response.Write "Transaction Abort"
   End Sub
%>
Message #2 by Greg Griffiths <greg2@s...> on Sat, 04 Jan 2003 18:27:41 +0000
A quick Google results in 
http://www.google.com/search?q=No+such+interface+supported+Transaction+Abort&hl=en&lr=&ie=UTF-8&sa=n&oq=No+such+
interface+supportedTransaction+Abort

At 04:02 04/01/03 +0000, you wrote:
>No such interface supportedTransaction Abort




  Return to Index