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
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