The above code fails at lds.settransobject( sqlca_doc). i.e returns -1.

i am using oracle database as the backend. i am setting the following parameters.

sqlca_doc.dbms = 'ORA Oracle'

sqlca.servername = 'name of the server'

sqlca.logid = 'username'

sqlca.logpass = 'password'

and it is connect to the database without any errors.

Any help would much appreciated.