0 Replies Latest reply on Jun 2, 2007 1:08 PM by Alejandro Dominguez

    JDBC & MS SQL: different databases

    Alejandro Dominguez Newbie

      Hi to all,
      I would like to develop an app for both Intersystem's Cache as well as MS SQL Server databases. Cache manages the concept of Namespaces which groups a number of tables, so, once I have my cache-ds.xml defined in /deploy I can access the tables nameSpace1.Table1, nameSpace1.Table2, but it also allows me to use nameSpace2.table1, all with just one datasource.

      The question is: is there anything similar in MS SQL? Can I, with one datasource, access different databases in my SQL service? Is there somewhere the concept of namespaces or something similar? Can I connect to 'master' and create for example a table in a different database?

      Regards

      Alejandro