TD-22619: Oledb - Transaction

Report SqlBase bugs and possible workarounds.
GianlucaN
Italy
Posts: 4
Joined: 29 Dec 2017, 14:00
Location: Italy

TD-22619: Oledb - Transaction

Post by GianlucaN » 21 Dec 2015, 16:10

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
You do not have the required permissions to view the files attached to this post.

VEspinal

Re: TD-22619: Oledb - Transaction

Post by VEspinal » 24 Dec 2015, 00:45

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
You do not have the required permissions to view the files attached to this post.

MWegner
Germany
Posts: 83
Joined: 11 Apr 2017, 07:39
Location: Germany

Re: TD-22619: Oledb - Transaction

Post by MWegner » 28 Dec 2015, 08:53

Hey Victor,

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

Best regards
Martin

VEspinal

Re: TD-22619: Oledb - Transaction

Post by VEspinal » 28 Dec 2015, 17:33

Yes Martin.

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

Thanks
Victor

GianlucaN
Italy
Posts: 4
Joined: 29 Dec 2017, 14:00
Location: Italy

Re: TD-22619: Oledb - Transaction

Post by GianlucaN » 29 Dec 2015, 09:43

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

Thanks
Gianluca

VEspinal

Re: TD-22619: Oledb - Transaction

Post by VEspinal » 29 Dec 2015, 13:22

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

Re: TD-22619: Oledb - Transaction

Post by VEspinal » 30 Dec 2015, 17:26

Hi Gianluca:

My bad ... sorry.

Working on your case now.

I will keep you posted on any results.

Thanks
Victor Espinal

VEspinal

Re: TD-22619: Oledb - Transaction

Post by VEspinal » 31 Dec 2015, 15:45

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 )

!!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
Italy
Posts: 4
Joined: 29 Dec 2017, 14:00
Location: Italy

Re: TD-22619: Oledb - Transaction

Post by GianlucaN » 07 Jan 2016, 12:51

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

Re: TD-22619: Oledb - Transaction

Post by VEspinal » 12 Jan 2016, 00:36

Hi:

Defect: TD-22619 has been logged.

We will keep you informed on any updates.

Thanks,
Victor Espinal

GianlucaN
Italy
Posts: 4
Joined: 29 Dec 2017, 14:00
Location: Italy

Re: TD-22619: Oledb - Transaction

Post by GianlucaN » 18 Jan 2016, 12:45

Ok,
I await news from you

Thanks

Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 0 guests