Hi Andres;
FYI: Currently, the "Other Options" setting values are only effective when communicating to an SQL Anywhere database.
Alternative1: My suggestion would be to use PB's "Execute Immediate" SQL command statement and send the SS DBMS specific "SET" commands for the DB Options that you wish to activate/de-activate. For example: "SET QUOTED_IDENTIFIER, ANSI_NULLS ON
".
Alternative2: Use a middleware client like OLE-DB, ADO.Net or ODBC for example. In the middleware, set the various DBParm settings you need from there to connect to SS as required.
HTH
Regards ... Chris
most of the options using both alternatives are working..
now i need to try to workaround the trustedconnection=1