-
Praburaj KarthiKeyan
- PowerBuilder
- Tuesday, 23 December 2025 12:04 PM UTC
Hi ,
I am currently facing an issue with the connection string after migrating from Appeon 2019 to Appeon 2022. The same connection string that worked perfectly in Appeon 2017,2019 is no longer functioning in the new version.
MSOLEDBSQL is V 18.xx
Error:- Could not connect to database... Error No.:-1. Description :- Invalid OLE DB provider name specified
Below is the connection string I have been using:
anv_trans.dbms = 'OLE DB'
anv_trans.Lock = "RC"
anv_trans.LogId = ls_LoginName
anv_trans.LogPass = ls_LoginPass
anv_trans.DBParm = "PROVIDER='MSOLEDBSQL',DATASOURCE='"+ls_Server+"',PROVIDERSTRING='Database="+ls_Database+";WSID="+UserProfile.of_GetHostString()+";App="+UserProfile.of_GetAppNameString()+"',CommitOnDisconnect='No',DelimitIdentifier='Yes',IdentifierQuoteChar='' , PackageProcs=1, StaticBind=1,RecheckRows=1"
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.