Back to all discussions

  •   about 9 years ago

Intersystems Cache Required

Is it a requirement to use Intersystem Cache or can we use another database tool?

  • 2 comments

  •   •   about 9 years ago

    Well, I mean, all the data is stored in the cache database. I'm not sure if there are any other tools that can interact with the .dat file.

    It would be like asking if you are required to use MySQL to access the contents of a MySQL database. I mean...no, but the level of difficulty of crafting your own goes up an order of magnitude.

    Here's something that might help you out -- Cache is easymode with this: http://docs.intersystems.com/cache20122/csp/docbook/DocBook.UI.Page.cls?KEY=BGOD_preface

  •   •   about 9 years ago

    Here is an example script in PHP to get you started:

    ---------------------------------------

    $conn = odbc_connect("DRIVER={InterSystems ODBC};Server=ca-XXXXXXX.vacloud.us;Port=1972;Database=CPM",
    "_system", "password");

    $sql = "SELECT TOP 30 * FROM VHAINO.APPOINTMENT";

    $result = odbc_do($conn, $sql);

    echo odbc_result_all($result);

Comments are closed.