- Xiaolong Qin
- PowerBuilder
- Tuesday, 15 May 2018 01:37 AM UTC
I had tried to use the "Auto Translate" with PB and MSSQL in OLED DB to
MSSQL, however I had found this parameter do not work !
I had tried this in PB 12 and PB2017 , also tried with MSSQL2000 and MSSQL2008,
but the it is do not work properly.
the connection info list as :
// Profile lib_sys
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass =
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='ANDREW',PROVIDERSTRING='Auto
Translate=false;Database=libsys',DelimitIdentifier='No'"
I had tried this in C#, "Auto Translate" work fine !
So do anyone have idea about what's wrong with this parameter in PB/MSSQL
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.