473,466 Members | 1,349 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

ODBC - Turning auto commit off

mvr
Hi all

I am runnig a Oracle procedure(this inserts records in table)
with asp.command object.
I dont want to commit the inserts, I want to turn auto-commit off when I
execute this procedure. Can this be done in ASP, if so, can some one give me
a example.
Any help will be really appreciated.

Thanks
mvr
Sep 9 '05 #1
0 1104

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Elbert Lev | last post by:
# W2K MSSQL-2000 import dbi, odbc myconn = odbc.odbc('DSN=db; UID=sa; PWD=') mycursor = myconn.cursor() mycursor.execute("SELECT ID, PWD FROM TABLE") rs = mycursor.fetchall() for ID, PWD...
7
by: Chris | last post by:
Hello, I posted a while back about a newbie database question and got a lot of great help here. My script that I am creating has come a long way (For me!) and almost does what I need it too. I...
0
by: mvr | last post by:
Hi all I am runnig a Oracle procedure(this inserts records in table) with asp.command object. I dont want to commit the inserts, I want to turn auto-commit off when I execute this procedure....
2
by: janet | last post by:
HI, I had a question on auto-commit in DB2 EEE V8 on AIX V5. Here is my example.. there are two script A.sh , B.SQL A.sh is following:
7
by: Ugrasena via DBMonster.com | last post by:
Hi team i am using DB2 7.2 on Windows2000. We have lot many SQL Procedure Calls, is there any way i can Turn off the Auto Commit on that Database, the Problem i have is many of our Application...
1
by: Marcel Czerny | last post by:
Hi, I've got some troubles with exporting data base entries from an "Access"-table (ver. 10) into an "Oracle"-table (ver. 9.2) using the "Oracle-ODBC-driver". At first I linked the...
9
by: Greg Strong | last post by:
Hello All, What is the maximum length of an ODBC pass through query? Things work fine with the code except when I try to create a view which is pretty complex in Oracle. I'm using a DSN...
0
by: Greg Corradini | last post by:
Hello all, I'm having trouble inserting an SQL selection into a new MS Access table. I get a parameter error on my insert statement when I try this (see below for code and error msg). I'm not sure...
1
by: drewbob | last post by:
Hello! I'm relatively new to oracle, so i hope I use the correct terminology. Please let me know if my question doesn't make sense! I'm trying to figure out how to turn off the session level...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.