A
abcd
I will be using ASP pages and connect to access DB. Does access support ADO
transactions through ASP pages?
thanks
transactions through ASP pages?
thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Danny J. Lesandrini
When you say "transactions" do you mean transactions, or do
you mean INSERT, UPDATE and DELETE statements?
I wrote up an article that shows (a little crudely) how to insert,
update and select records from an Access database from ASP.
The download includes a form that, when imported into your
application, will create the ASP page with code to do the above.
As for Transactions, that may be handled in ADO as well, though
I don't remember the syntax off the top of my head. Whatever
it looks like, it will undoubtedly look something like this:
cnn.BeginTransaction
cnn.Execute strSQL
If Err.Number = 0 Then
cnn.CommitTransaction
Else
cnn.RollbackTransaction
End If
Is this the syntax you're looking for?
you mean INSERT, UPDATE and DELETE statements?
I wrote up an article that shows (a little crudely) how to insert,
update and select records from an Access database from ASP.
The download includes a form that, when imported into your
application, will create the ASP page with code to do the above.
As for Transactions, that may be handled in ADO as well, though
I don't remember the syntax off the top of my head. Whatever
it looks like, it will undoubtedly look something like this:
cnn.BeginTransaction
cnn.Execute strSQL
If Err.Number = 0 Then
cnn.CommitTransaction
Else
cnn.RollbackTransaction
End If
Is this the syntax you're looking for?
D
Danny J. Lesandrini
FWIW
Search Google Groups for ADO Connection Transaction and
you'll find plenty of old posts on using Transactions with ADO
and ASP pages. (in the ASP newsgroups.)
http://groups.google.com/group/micr...on+group:*asp*&rnum=19&hl=en#e8748a8ee9b993fb
Search Google Groups for ADO Connection Transaction and
you'll find plenty of old posts on using Transactions with ADO
and ASP pages. (in the ASP newsgroups.)
http://groups.google.com/group/micr...on+group:*asp*&rnum=19&hl=en#e8748a8ee9b993fb
A
abcd
Thanks Danny.
Yes you are right. I was looking ofr Begintrans syntax and you have
explained very well.
my another question is that is Access transaction based database system?
if I use beginTrans of ADO connection connection object with Access as
backend am I be getting the same effect as connecting to SQL Server which is
Transactional DBMS
Yes you are right. I was looking ofr Begintrans syntax and you have
explained very well.
my another question is that is Access transaction based database system?
if I use beginTrans of ADO connection connection object with Access as
backend am I be getting the same effect as connecting to SQL Server which is
Transactional DBMS
P
Pieter Wijnen
yes it is
Pieter
Pieter
abcd said:Thanks Danny.
Yes you are right. I was looking ofr Begintrans syntax and you have
explained very well.
my another question is that is Access transaction based database system?
if I use beginTrans of ADO connection connection object with Access as
backend am I be getting the same effect as connecting to SQL Server which
is Transactional DBMS