Hi,

I hope this finds everyone well!

I have C# application that could benefit from lookup tables in DBISAM format.

We do have the ODBC access, but I think that would require a running server (correct me). I'm more interested in embedding the engine. It's all about ease of use for the clients.

Has anyone built an OLE/COM encapsulation of DBISAM? With an COM module, we could use DBISAM tables from Microsoft Office as well.

It could be fairly crude, [open session, run SQL, output CSV, close session].

I apologize in advance for another 'Thor's Hammer' approach to a programming solution!

All the best,
'Fire Marshall' Jim

On 2/20/2018 11:09 AM, Shedden wrote:
> I have C# application that could benefit from lookup tables in DBISAM format.
> We do have the ODBC access, but I think that would require a running server (correct me). I'm more interested in embedding the engine. It's all about ease of use for the clients.

No server needed - DBISAM ODBC can be configured as a local engine -
meaning connection type is local and DBISAM data is accessible thru a
folder/file path (local or LAN based using SMB style path).

You'd still need to install (or automate install) of ODBC drivers though
AFAIK.

in terms of options for connection strings:
https://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4odbc&topic=Connection_Strings


Raul

Hi Raul,

I appreciate your help! I have an interim solution already running, but I'm about to give the ODBC a try! I'm sure that it will be a more elegant and permanent solution.

Sometimes we have to hack, but I do try to go back and improve!

I thought of the COM automation because I'd done it years ago in both Visual Basic and Delphi. Delphi was the champ. It was very easy to write a component.

All the best,
Jim