>>>I need to access VFP tables encrypted with Cryptor from a Ruby on Rails app. I plan to use VfpOleDb.dll to read the tables and send information to Ruby.
>>>
>>>Cryptor encrypts and unencrypts data on the fly but it needs to be set up. How do you tell VfpOleDb.dll to run a VFP exe (which will call Cryptor).
>>>
>>>TIA,
>>>
>>>Alex
>>
>>Call from Ruby a COM component writen in vfp or run a server process offering txt/json text via web interface with a server able to call up a vfp COM component.
>>You might do it in C as well, but root canal treatment would be nice compared to it for my taste...
>
>I believe this has the code you are looking for: http://forum.strataframe.net/PrintTopic9424.aspx
>
>It's aimed toward .Net, but it will just be easier in Rails.
>
>hth,
>
>Hank
>
>PS: I googled on: cryptor vfpoledb

Hi Hank,

You totally surprised me with that reference! It is the exact same problem I am trying to solve again, now using Ruby on Rails.

I gave up on Strataframe and .NET long ago and I didn't have any code left other than the one you sent in that message. Thanks for that.

Alex