TD-22619: Oledb - Transaction

[GianlucaN]

Hi,
I have a problem with t.d. 6.3 and sql transaction.
I migrated our project from t.d. 5.2 to 6.3.
In 5.2 everything works correctly, but in 6.3, if i connect a new cursor in a transaction before it's committed, the transaction is lost and the command INSERT/UPDATE/DELETE it's not commit.
I attach an example for explain my problem.

Thanks
Gianluca

[VEspinal]

Hi Gianluca:

Your reprocase does not work on TD 5.2 either.

Please see attached pictures.

Can you please provide a revised one?

Thanks in advance.

Best Regards,
Victor Espinal

[MWegner]

Hey Victor,

you have to fill out the login data like sqluser password and database

Best regards
Martin

[VEspinal]

Yes Martin.

I am able to get connected to the DB and I did enter the end user, password and database.

Thanks
Victor

[GianlucaN]

Hi,
I've retested my example.
If you specify a correct OLEDB connectionstring in gsOleDbConnection, the example works as described.

Thanks
Gianluca

[VEspinal]

Hi:

I just followed your OLEDB connection using my end user, database name and password and it does not work on TD 5.2 nor TD 6.3.

Thanks
Victor

[VEspinal]

Hi Gianluca:

My bad ... sorry.

Working on your case now.

I will keep you posted on any results.

Thanks
Victor Espinal

[VEspinal]

Hi:

v5.2 up to v6.0 SP3 – Work - Insert does implicit COMMIT
v6 SP4 and later – Broken - Insert does implicit ROLLBACK

Work Around: Call SqlSetParameter() after connect ....
Call SqlSetParameter( i_hSql, DBP_AUTOCOMMIT, TRUE, STRING_Null )

Code: Select all

!!CB!! 278
Function: fnInsert
	Description:
	Returns
	Parameters
	Static Variables
	Local variables
	Actions
		Call fnSqlSecureConnect( i_hSql )
		Call SqlSetParameter( i_hSql, DBP_PRESERVE, TRUE, STRING_Null )
		Call SqlSetParameter( i_hSql, DBP_AUTOCOMMIT, TRUE, STRING_Null )

....
....

Please let me know if the above workaround works for you.

Thanks in advance.

Regards,
Victor Espinal

[GianlucaN]

I'm sorry but i cannot use in my project the workaround that you have suggested me.
I'm waiting for a solution.

Thanks

[VEspinal]

Hi:

Defect: TD-22619 has been logged.

We will keep you informed on any updates.

Thanks,
Victor Espinal

[GianlucaN]

Ok,
I await news from you

Thanks