- sachidhanantham ramalingam
- PowerBuilder
- Tuesday, 14 June 2022 09:47 AM UTC
Hi,
We have migrated PB 2017 to PB 2019 R3 and need to change the DBMS = "SNC SQL Native Client(OLE DB)" to "MSOLEDBSQL SQL Server",
So, we want your suggestion that do we need to include "Provider = 'MSOLEDBSQL'" in SQLCA.DBParm string or not, since previously we haven't included any "Provider" information in SQLCA.DBParm string.
Our existing SQLCA.DBParm string:
------------------------------------------
SQLCA.DBParm = "DBTextLimit='32000',TrimSpaces=1,ProviderString='MARS Connection=False',"+ls_Host+",Database='"+SQLCA.Database+"',FailoverPartner='"+ls_FailOverServer+"',Initial Catalog='"+SQLCA.Database+"'"
Thanks,
--Sachi...
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.