Re: Manual commit ODBC transactions?

#1 (**permalink**) 04-19-2008, 09:15 PM

--0__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7
Content-type: multipart/alternative;
Boundary="1__=08BBE416DFC79EE78f9e8a93df938690918c 08BBE416DFC79EE7"

--1__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7
Content-type: text/plain; charset=US-ASCII

Hi Rob,

I am not very familiar with ODBCExpress. However, I would like to give you
an idea about how you can do the same using small ODBC application.

First of all you have to make sure what type of database you are dealing
with i.e. logging, bufferd logging or ANSI. For more info pl. refer your
Server Administrator's Guide.
http://publib.boulder.ibm.com/epubs/pdf/ct1ucna.pdf

You might also want to refer IBM Informix ODBC Programmers's manual, see
page #56-57. http://publib.boulder.ibm.com/epubs/pdf/ct1ufna.pdf

For example lets assume you are working with ANSI database, your ODBC C app
would look like as follows to perform the manual commit.

Create your DSN with default settings. That means let the "Auto Commit
Optimization" check box be checked.

1. Allocate required handles.
2. SQLConenct/SQLDriverConnect ( ...."connect with ANSI database" .....);
3. Set SQL_ATTR_AUTOCOMMIT attribute to SQL_AUTOCOMMIT_OFF using
SQLSetConnectAttr.
4. Allocate statement handle.
5. Execute "Begin work;" using SQLExecDirect(); // This will start the
transaction.
6. Do whatever you want ....select, insert, update etc.
7. Execute SQLEndTran either with SQL_ROLLBACK or SQL_COMMIT. // This will
end the transaction after performing the necessary operation.
8. Do necessary cleanup.

I am hoping if you are connecting to ANSI database then even using
ODBCExpress you should be able to run it successfully, if you are sure
that the above steps are being taken care under the cover.

HTH

Thanks
-Shesh

Rob
<nospam@nowhere.c To: informix-list@iiug.org
om> cc:
Sent by: Subject: Manual commit ODBC transactions?
owner-informix-li
st@iiug.org

04/27/2004 07:44
AM
Please respond to
Rob

Hello,

When attempting a manual commit, I receive a "Driver not capable" error
message.

Is it possible to use manual transactions with Informix v9.4 and ODBC
driver v3.82 ? I tried the ODBC advanced setup option "Auto commit
optimization" both ways with the same result.

I am using ODBCExpress with StartTransact(), Commit(), and EndTransact()
sequence to manually manage transactions. This works great with MSSQL.

Is there a better ODBC driver available?

Rob.

--1__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline

<html><body>
Hi Rob, 
 
I am not very familiar with ODBCExpress. However, I would like to give you an idea about how you can do the same using small ODBC application. 
 
First of all you have to make sure what type of database you are dealing with i.e. logging, bufferd logging or ANSI. For more info pl. refer your 
Server Administrator's Guide. <a href="http://publib.boulder.ibm.com/epubs/pdf/ct1ucna.pdf">http://publib.boulder.ibm.com/epubs/pdf/ct1ucna.pdf</a> 
 
You might also want to refer IBM Informix ODBC Programmers's manual, see page #56-57. <a href="http://publib.boulder.ibm.com/epubs/pdf/ct1ufna.pdf">http://publib.boulder.ibm.com/epubs/pdf/ct1ufna.pdf</a> 
 
For example lets assume you are working with ANSI database, your ODBC C app would look like as follows to perform the manual commit. 
 
Create your DSN with default settings. That means let the "Auto Commit Optimization" check box be checked. 
 
1. Allocate required handles. 
2. SQLConenct/SQLDriverConnect ( ...."connect with ANSI database" .....); 
3. Set SQL_ATTR_AUTOCOMMIT attribute to SQL_AUTOCOMMIT_OFF using SQLSetConnectAttr. 
4. Allocate statement handle. 
5. Execute "Begin work;" using SQLExecDirect(); // This will start the transaction. 
6. Do whatever you want ....select, insert, update etc. 
7. Execute SQLEndTran either with SQL_ROLLBACK or SQL_COMMIT. // This will end the transaction after performing the necessary operation. 
8. Do necessary cleanup. 
 
I am hoping if you are connecting to ANSI database then even using ODBCExpress you should be able to run it successfully, if you are sure 
that the above steps are being taken care under the cover. 
 
HTH 
 
Thanks 
-Shesh 
 
<img src="cid:10__=08BBE416DFC79EE78f9e8a93df938@us.ibm .com" width="16" height="16" alt="Inactive hide details for Rob <nospam@nowhere.com>">Rob <nospam@nowhere.com> 
 
 

<table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img src="cid:20__=08BBE416DFC79EE78f9e8a93df938@us.ibm .com" border="0" height="1" width="72" alt=""> 
</td><td style="background-image:url(cid:30__=08BBE416DFC79EE78f9e8a93df938@u s.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE416DFC79EE78f9e8a93df938@us.ibm .com" border="0" height="1" width="225" alt=""> 

<ul>
<ul>
<ul>
<ul>Rob <nospam@nowhere.com> 
Sent by: owner-informix-list@iiug.org
04/27/2004 07:44 AM 
Please respond to Rob</ul>
</ul>
</ul>
</ul>
</td><td width="100%"><img src="cid:20__=08BBE416DFC79EE78f9e8a93df938@us.ibm .com" border="0" height="1" width="1" alt=""> 
 
 To: informix-list@iiug.org 
 cc: 
 Subject: Manual commit ODBC transactions?</td></tr>
</table>
 
 
 
Hello, 
 
When attempting a manual commit, I receive a "Driver not capable" error 
message. 
 
Is it possible to use manual transactions with Informix v9.4 and ODBC 
driver v3.82 ? I tried the ODBC advanced setup option "Auto commit 
optimization" both ways with the same result. 
 
I am using ODBCExpress with StartTransact(), Commit(), and EndTransact() 
sequence to manually manage transactions. This works great with MSSQL. 
 
Is there a better ODBC driver available? 
 
Rob. 


</body></html>

--1__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7--

--0__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=08BBE416DFC79EE78f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7

--0__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <20__=08BBE416DFC79EE78f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7

--0__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7
Content-type: image/gif;
name="pic24621.gif"
Content-Disposition: inline; filename="pic24621.gif"
Content-ID: <30__=08BBE416DFC79EE78f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH
ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT
mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw
9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb
jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl
fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA
Ow==

--0__=08BBE416DFC79EE78f9e8a93df938690918c08BBE416DF C79EE7--

sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode