By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

UDB v 8.1 - SQL0925N SQL COMMIT invalid for application execution

P: n/a
Hi,

I am using UDB v 8.1 on win2000.

I have setup the ODBC datasources.

My application is connecting to the database and performing DML
activities. But I am getting the following error

SQL0925N SQL COMMIT invalid for application execution environment.
SQLSTATE=2D521

My db2cli.ini settings are
[DTPVPD02]
DEFERREDPREPARE=0
CURSORHOLD=0
CURRENTSCHEMA=VIPS
CONNECTTYPE=2
SYNCPOINT=2
AUTOCOMMIT=0
DBALIAS=DTPVPD02

Application works perfectly fine in UDB v7.2

Is the CONNECTTYPE=2 and SYNCPOINT=2 are supported in UDB v8.

If not what is the equivalent settings needs to be in db2cli.ini

Would appreciate your help.

cheers
vijai
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.