|
 |
asp_databases thread: Error No such interface supported
Message #1 by "Thang Nguyen" <thangnh_1999@y...> on Sat, 4 Jan 2003 03:58:59
|
|
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.0
*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 "Ron Williams" <ronwilliams32@c...> on Tue, 7 Jan 2003 21:19:17
|
|
hey dude,
i might be able to help more if you take out the 'on error resume next'
and get the line number of the error when you run the code. you may get a
more descriptive error and be able to resolve it yourself. 'on error
resume next' is not good to use when you are debugging and troubleshooting
because of the interpretive nature of ASP.
ron
> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
when
r> un below code ,
W> eb browser appear message : <font color="red">No such interface
s> upported</font>
C> an you help me to solve this prolem?
> *OS WIN2K
*> IIS 5.0
*> Database : AccessXP
>
E> rror: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 #3 by "Thang Nguyen" <thangnh_1999@y...> on Wed, 8 Jan 2003 09:52:26
|
|
Hi, I remove 'on error resume next' out my programm,and Web browser
messege that:
Error Provider (0x80004002) No such interface supported.
So what error? and way to fix this error?
Thank you.
> hey dude,
> i might be able to help more if you take out the 'on error resume next'
a> nd get the line number of the error when you run the code. you may get
a
m> ore descriptive error and be able to resolve it yourself. 'on error
r> esume next' is not good to use when you are debugging and
troubleshooting
b> ecause of the interpretive nature of ASP.
> ron
>
>> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
w> hen
r> > un below code ,
W> > eb browser appear message : <font color="red">No such interface
s> > upported</font>
C> > an you help me to solve this prolem?
> > *OS WIN2K
*> > IIS 5.0
*> > Database : AccessXP
> >
E> > rror: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 #4 by "Anand" <info@s...> on Wed, 8 Jan 2003 15:41:45 +0530
|
|
You must be using older version of ASP. What is your operating system and
which server are you using (IIS or Personal web server) also let me know the
version of it and Service Pack.
Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar, Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Thang Nguyen" <thangnh_1999@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, January 08, 2003 9:52 AM
Subject: [asp_databases] Re: Error No such interface supported
> Hi, I remove 'on error resume next' out my programm,and Web browser
> messege that:
>
> Error Provider (0x80004002) No such interface supported.
> So what error? and way to fix this error?
> Thank you.
>
> > hey dude,
>
> > i might be able to help more if you take out the 'on error resume next'
> a> nd get the line number of the error when you run the code. you may get
> a
> m> ore descriptive error and be able to resolve it yourself. 'on error
> r> esume next' is not good to use when you are debugging and
> troubleshooting
> b> ecause of the interpretive nature of ASP.
>
> > ron
>
> >
> >> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
> w> hen
> r> > un below code ,
> W> > eb browser appear message : <font color="red">No such interface
> s> > upported</font>
> C> > an you help me to solve this prolem?
>
> > > *OS WIN2K
> *> > IIS 5.0
> *> > Database : AccessXP
> > >
> E> > rror: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 #5 by "Thang Nguyen" <thangnh_1999@y...> on Wed, 8 Jan 2003 14:00:57
|
|
What is older version of ASP? Now I using IIS 5 and OS Win 2000 Pro, I
don't use Service Pack for Win 2000 Pro.
Best regards
Thang
> You must be using older version of ASP. What is your operating system and
which server are you using (IIS or Personal web server) also let me know
the
version of it and Service Pack.
Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar, Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Thang Nguyen" <thangnh_1999@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, January 08, 2003 9:52 AM
Subject: [asp_databases] Re: Error No such interface supported
> Hi, I remove 'on error resume next' out my programm,and Web browser
> messege that:
>
> Error Provider (0x80004002) No such interface supported.
> So what error? and way to fix this error?
> Thank you.
>
> > hey dude,
>
> > i might be able to help more if you take out the 'on error resume next'
> a> nd get the line number of the error when you run the code. you may
get
> a
> m> ore descriptive error and be able to resolve it yourself. 'on error
> r> esume next' is not good to use when you are debugging and
> troubleshooting
> b> ecause of the interpretive nature of ASP.
>
> > ron
>
> >
> >> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
> w> hen
> r> > un below code ,
> W> > eb browser appear message : <font color="red">No such interface
> s> > upported</font>
> C> > an you help me to solve this prolem?
>
> > > *OS WIN2K
> *> > IIS 5.0
> *> > Database : AccessXP
> > >
> E> > rror: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 #6 by "Ron Williams" <ronwilliams32@c...> on Wed, 8 Jan 2003 19:26:37
|
|
Sub OnTranactionCommit()
try putting an "s" between the n and the a and see what happens.
ill run the code at home tonight to see what i get. but try it without
misspelled words first.
> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
when
r> un below code ,
W> eb browser appear message : <font color="red">No such interface
s> upported</font>
C> an you help me to solve this prolem?
> *OS WIN2K
*> IIS 5.0
*> Database : AccessXP
>
E> rror: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 #7 by "Ron Williams" <ronwilliams32@c...> on Thu, 9 Jan 2003 00:43:08
|
|
YOUR ANSWER:
Microsoft Access has no resource manager so it will not support the
@Transaction directive. that is what the error:
Error Provider (0x80004002) No such interface supported
is trying to tell you. it doesnt support that @Transaction interface.
you need to use SQL Server or MSDE or some other provider that has support
for that directive.
later,
ron
> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
when
r> un below code ,
W> eb browser appear message : <font color="red">No such interface
s> upported</font>
C> an you help me to solve this prolem?
> *OS WIN2K
*> IIS 5.0
*> Database : AccessXP
>
E> rror: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 #8 by "Anand" <info@s...> on Thu, 9 Jan 2003 12:05:50 +0530
|
|
I hope, he must be satisfied with this answer, which I was too looking for.
Thanks and regards
Anand Bisht
eBusiness Application Developer - Consultant
668, 6th Main, 7th Cross, HAL 2nd Stage,
Indiranagar, Bangalore - 560008 (India)
E-mail: info@s...
Phone Res: +xx xx xxxxxxx
Phone Off: +xx xx xxxxxxx / xxxxxxx x 24
----- Original Message -----
From: "Ron Williams" <ronwilliams32@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, January 09, 2003 12:43 AM
Subject: [asp_databases] Re: Error No such interface supported
> YOUR ANSWER:
>
> Microsoft Access has no resource manager so it will not support the
> @Transaction directive. that is what the error:
>
> Error Provider (0x80004002) No such interface supported
>
> is trying to tell you. it doesnt support that @Transaction interface.
>
> you need to use SQL Server or MSDE or some other provider that has support
> for that directive.
>
> later,
>
> ron
>
>
>
>
> > Hi , I wrote a sample code about Transaction in ASP and AccessXP but
> when
> r> un below code ,
> W> eb browser appear message : <font color="red">No such interface
> s> upported</font>
> C> an you help me to solve this prolem?
>
> > *OS WIN2K
> *> IIS 5.0
> *> Database : AccessXP
> >
> E> rror: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 #9 by "Ron Williams" <ronwilliams32@c...> on Thu, 9 Jan 2003 20:15:47
|
|
I got that answer from Beginning Active Server Pages 3.0, p. 781 (WROX)
> Hi , I wrote a sample code about Transaction in ASP and AccessXP but
when
r> un below code ,
W> eb browser appear message : <font color="red">No such interface
s> upported</font>
C> an you help me to solve this prolem?
> *OS WIN2K
*> IIS 5.0
*> Database : AccessXP
>
E> rror: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 #10 by "Thang Nguyen" <thangnh_1999@y...> on Fri, 10 Jan 2003 16:10:46
|
|
Finally, I understand prolem from your helping.
And Thanks for all your helping
> I got that answer from Beginning Active Server Pages 3.0, p. 781 (WROX)
> > Hi , I wrote a sample code about Transaction in ASP and AccessXP but
w> hen
r> > un below code ,
W> > eb browser appear message : <font color="red">No such interface
s> > upported</font>
C> > an you help me to solve this prolem?
> > *OS WIN2K
*> > IIS 5.0
*> > Database : AccessXP
> >
E> > rror: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
%> > >
|
|
|
View Cart
