Fast forward to Strataframe.  I need to access those tables from Strataframe both at runtime and at design time.  Runtime seems straightforward (though I haven't done it yet  ), but where would you place the equivalent code in the development environment so that the BO mapper can access the encrypted dbf?

Thanks,

Alex

poCryptor = CreateObject("XitechCryptor.Cryptor")

poCryptor.WatchDLL("oledb32.dll")

MyCryptor('plemp.dbf')

LOCAL oConn as "adodb.connection"

LOCAL oRS as "adodb.recordset"

oConn = CREATEOBJECT('adodb.connection')

oRS = CREATEOBJECT('adodb.recordset')

cConnStrng = "Provider=vfpoledb;Data Source=" + "z:\VPay950\Contab\sosa"

oConn.Open(cConnStrng)

oRS = oConn.Execute("SELECT * FROM plemp")

?oRS.Fields("ccodemp").Value

oRS.Close()

oConn.Close()

FUNCTION MyCryptor

PARAMETER tcFile

lcPassword = 'password'

lnAlgorithmNumber = xxx

poCryptor.Register(tcFile,lcPassword,lnAlgorithmNumber)

I think the BO Mapper will have no problem mapping your VFP table. Have you gone through the process to do it? (create your BO in your project, go to BOMapper, right-click your project and go to Properties, fill in the OLE DB Connection String, right-click you BO, choose Properties and select OLE DB from the radio button group and them Select Source button.) This should take you to your .DBC, letting you choose your .dbf

I'm not sure where your Encryptor should be instantiated, but I guess the guys here will have a good idea to give you.

Abraços.

Good idea about using unencrypted files to map the schemas, and I may have to do that.  In the mean time, when testing the the run-time access I found a rights problem instantiating the Cryptor object.  This is not a Strataframe problem, of course, just a result of being new to .NET, but could you give me some guidance, please?  Thanks.

Alex

At this point an error ocurrs at runtime: Security exception was unhandled.

Imports XitechCryptorModule Module1
    Public oXitechCryptor As XitechCryptor.Cryptor
    Sub Main()
        ' Instantiate Cryptor and tell it to watch disk access by oledb32.dll
        oXitechCryptor = New XitechCryptor.Cryptor()
 
System.Security.SecurityException was unhandled
  Message="System.Security.Permissions.SecurityPermission"
  Source="ConsoleApplication1"
  StackTrace:       at ConsoleApplication1.Module1.Main()
       at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.runTryCode(Object userData)
       at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()

Start -> Control Panel -> Administrative Tools -> Microsoft.NET Framework 2.0 Configuration

You will want to adjust the Zone Security for your computer.  Select the Local Intranet and provide Full Trust.  This is the first place I would look.

Exactly, thank you.  Some day I will know enough about .NET as I know of VFP, hopefully.

Alex

You are already well on your way.  It is just like anything else, you just have to familiarize yourself with it and then you move forward faster and faster.