>>>I need to access some VFP tables that are encrypted using Cryptor from Ruby on Rails
>>>
>>>From VFP it's done like this:
>>>
>>> Instantiate the Cryptor OLE object
>>> Tell the Cryptor object to expect calls from vfp ==> oCryptor.WatchDLL("vfp9r.dll")
>>> Tell the Cryptor object which tables are encrypted and the passwords
>>>
>>>VFP tables should be accessible from RoR using the VFPoledb object I believe
>>>
>>>The problem is I am a RoR newbie and don't know how to instantiate and use an OLE object or how to tell RoR to use the VFPOleDB object.
>>
>>My understanding is RoR was originally developed on a non-Windows platform. OLE/ActiveX is Windows-only so base RoR won't support it. There may be an add-on for RoR deployed on Windows that supports it but you'd need to confirm that.
>>
>>VFP and Cryptor are also Windows-only. Assuming you get past the hurdle above, your RoR deployment, VFP runtime, and Cryptor would almost certainly need to be on the same computer, and the encrypted VFP tables either on that same computer or accessible via Windows networking. That limits your deployment options but if you're doing this for a single client that may not be an issue.
>>
>>It might be cleaner to create a Windows process (VFP EXE or something else) that can open the encrypted tables, and listen to and respond to requests using some web protocol such as http. That way the RoR deployment can live on a different computer (even running Linux). I imagine West Wind Web Connect or some part of it can do that. I think I've also seen code samples floating around that let a VFP EXE listen on a TCP port and respond to requests.
>>
>>Another way to do something similar would be to copy the data that need to be secured in another DB product such as MySQL, which can then easily be accessed from RoR.
>
>Hi Al,
>
>From what you say the key question is, can instantiate OLE objects from Ruby?
>
>Since I am pretty sure Ruby will be able to communicate with VfpOleDb.dll when running in a windows machine, the second question would be how to tell VfpOleDB to run a vfp program (that calls Cryptor) when it initializes? I'll ask it in another thread here.

I think you need to be more than "pretty sure". If that part isn't there you'll have to re-architect the whole thing, you could end up wasting a lot of time.