- Connie Dove
- PowerBuilder
- Tuesday, 3 May 2022 07:44 PM UTC
We have been using ODBC connections for our Powerbuilder applications for many years. Until recently the applications were in Powerbuilder 10 or 12.5. The applications had been running fine and did not seem to have issues.
Recently we have upgraded the applications to Powerbuilder 2019R3 and are now having issues with the applications running slow, or closing when doing an update.
What is the best connection to use now against MS SQL 2017 and eventually 2019?
Here is what our 32 bit ODBC settings look like.
[HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"OFMABSQA2017"="SQL Server"
[HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBC.INI\OFMABSQA2017]
"Driver"="sqlsrv32.dll"
"Description"="OFMABSQA2017"
"Server"="server1"
"Database"="ofmbilling_db"
"AnsiNPW"="No"
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.