Re: [AccessD] InterSystems Caché database engine

Hi Jim

Yes, they claim an ODBC driver to be available:

  http://www.intersystems.com/cache/cache5/fb/fb_02.html
  http://www.intersystems.com/cache/fusion/cache-prd_05.html

and note 3 here:

  http://www.intersystems.com/cache/product-tables/current-prodlist.html

That could be the answer to your question.

/gustav


> To be honest I never even gave Access a thought.  I was pretty focused on the OO syntax for accessing data that I never got that far.  Are there ODBC drivers for it?  

> I never saw where/how the data was stored since they don't use table structures.  That was one of the issues I wanted to discuss with then (does one have to write an app to see the data because you
> can't double click a table?) and how to interface with VB/VBA.

> Jim

> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Tuesday, September 16, 2003 8:58 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] InterSystems Caché database engine


> Hi Jim

> How would you judge its relevance to Access? Either as a backend with
> ODBC interface or as an "extension" to VBA?

> /gustav


>> Gustav,

>> I've played with Cache a bit on its own (no Access or VB FE).  I found it interesting because it's an object oriented DBMS as opposed to relational (you can use SQL with joins etc).  If you follow
>> their tutorial you'll see how very easy it is to get a web based app together.  I never had time to continue "playing" with it but the concept makes complete sense to me.  On the down side, a
>> planned tech support call (them calling me) to answer some questions I had about the data storage never happened (without explaination).  

>> Jim DeMarco
>> Director of Product Development
>> HealthSource/Hudson Health Plan


>> -----Original Message-----
>> From: Gustav Brock [mailto:gustav at cactus.dk]
>> Sent: Tuesday, September 16, 2003 5:29 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] InterSystems Caché database engine


>> Hi group

>> Just noticed this option for a free developer license:

>>   http://www.intersystems.com/downloads/index.html

>> Anyone having experience with this engine as a backend for Access or
>> otherwise?

>> The free license doesn't allow you to sell your apps. It is, however,
>> not time limited.

>> /gustav