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…
You are currently browsing all posts tagged with Connection string
PowerBuilder – SQL Native Client Transaction Persistance
PowerBuilder – Connect to SQLite version 3 database (ODBC)
If you are interested in doing PowerBuilder development with an SQLite database here is the DSN Less connection string to get you going. string ls_dbparm, ls_dbfile, ls_exepath, ls_file[] ls_dbfile = c:\temp\sqlite.db3' IF Fileexists(ls_dbfile) THEN // do nothing ELSE IF GetFileOpenName('Select Data File',ls_dbfile, ls_file,'db3','SQLite files (*.db3),*.db3') < 1 THEN Messagebox('No Data File Chosen','Application will close') HALT…