Support of Catalog and schemas

Classic Servoy
1

I am evaluating Servoy in connection with databases MS SQL and Cache (Intersystems).
I got some problems to access some tables in those databases.

  1. With MS SQL server 2000, when I try to fill the catalog parameter in DBServers preferences I get this message:

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer] CATALOG is not a recognized SET statement.

Without specifying catalog I can only access the catalog with the full access rights for this catalog.

  1. With Cache Database, I cannot specify schema in DB Servers preferences, otherwise I get the message:

[SQLCODE: <-1>:]
[Cache Error: <errdone+1^%qaqqt>]
[Details: ]
[%msg: < SQL ERROR #1: OPTION expected, SCHEMA found^SET SCHEMA>]

With the same JDBC driver with DBVisualizer, I can see the different schemas and the different tables in a hierarchical view.
In Servoy, without specifying schemas, I get a flat view of all the tables of the different schemas and I can build forms with the fields of the tables. But in execution mode, I get an error message because Cache DB prefixes the table name with SQLUSER. when no schema is provided in the request. In consequence the Cache DB does not find the table used in the form.

Could someone provide me with some guidelines to be able to use Servoy to access those DB ?

Thanks.