PowerBuilder – SQL Native Client Transaction Persistance

Posted on Tuesday, December 17th, 2013 at 10:08 am in

There can be an issue with transactions not being disconnected from SQL Server when using the SQL Native Driver (SQLNCLIxx driver). In my case when the application was closed, the transactions were held open for up to four minutes. This may not be an issue with a small number of connections but with a large user base it can be problematic.

To correct this you need to add an Extended Property to the Database Profile Setup. The entry is “OLE DB Services=-4”.

This changes your connection string to something like:

SQLCA.DBParm = “Provider=’SQLNCLI10′,Database=’myDB’,ProviderString=’OLE DB Services=-4′