|
 |
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
|
|
 |