ADODB eScript programmers: be aware about the Bug 18390659 "... ADODB.CONNECTION: SETTING CURSORLOCA
Hello Siebel eScript programmers,
who use ADODB COM Objects to access exteranl Db (e.g. the Oracle DB).
Be aware, that after upgrade to 8.1.1.11, setting of the "CursorLocation" property will throw the error:
Unahdled Exception: Arguments are of the wrong type, are out of acceptable range, or are in conflict with another.
example of the impacted code:
"...
var oc = COMCreateObject("ADODB.Connection");
oc.Mode = 3;
oc.ConnectionString = "Provider=OraOLEDB.Oracle;Persist Security Info=False;Data Source=MYODBC;User Id=MYUSER;Password=MYPWD;";
oc.CursorLocation = 3; // This code works FAILS in 8.1.1.11 (while it was working in any earlier release).
oc.Open();
..."
As per MS