
Tony Nguyen • about 9 years ago
Intersystems Cache Required
Is it a requirement to use Intersystem Cache or can we use another database tool?
Comments are closed.
Tony Nguyen • about 9 years ago
Is it a requirement to use Intersystem Cache or can we use another database tool?
Comments are closed.
2 comments
Justin Mealey • 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
Justin Mealey • 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);