I know external modules can be used with EDB, but I'm pretty much =
clueless about how to implement them.

This is about all I have from the SQL help file:=20
 " External modules can be created in any language that can generate a =
DLL (Dynamic Link Library) with a C-style calling convention, which is =
the standard calling convention for DLLs under Windows.  In addition, =
ElevateDB provides template projects for the various types of external =
modules in every specific compiler or IDE that it supports.  Please see =
your product-specific manual for more information."

Would anyone have any ideas about any of the following:
-where might the templates be? Anyone use any of the templates with VS =
2008?
-can .Net DLLs be used as long as the appropriate Framework is installed =
on the DB server?
-has anyone used them? if so, any suggestions or thoughts or maybe some =
gotchas with the learning curve? I've not found any templates so far.


This is my planned intent: I'm going to have a few fields that are =
encrypted using Rijndael not by EDB because I need the values encrypted =
when the EDB Mgr is used @ any given time. The encryption is going to =
stop me from using any select statements. My thoughts are to use an =
external module to read the records, decrypt them, validate they need to =
be in the select, re-encrypt, populate them to a cursor and return the =
encrypted cursor accross the network. Assuming the encryption key & SALT =
would be known by the app & the EDB server.

Thanks


jr

James,

<< Would anyone have any ideas about any of the following:
-where might the templates be? Anyone use any of the templates with VS 2008?
>>

There aren't any templates for VS at this time.  However, I can send you a
prototype of the functions that are needed in the DLL.

<< -can .Net DLLs be used as long as the appropriate Framework is installed
on the DB server? >>

No, but I'm going to be adding .NET assembly support shortly for the the
..NET data provider, so it may be in your interest to wait for that instead
of trying to code a DLL in VC++.

<< This is my planned intent: I'm going to have a few fields that are
encrypted using Rijndael not by EDB because I need the values encrypted when
the EDB Mgr is used @ any given time. The encryption is going to stop me
from using any select statements. My thoughts are to use an external module
to read the records, decrypt them, validate they need to be in the select,
re-encrypt, populate them to a cursor and return the encrypted cursor
accross the network. Assuming the encryption key & SALT would be known by
the app & the EDB server. >>

Are you wanting to do this every time a SELECT statement is executed, or
only have this work with specific stored procedures ?

--
Tim Young
Elevate Software
www.elevatesoft.com

> No, but I'm going to be adding .NET assembly support shortly for the =
the=20
> .NET data provider, so it may be in your interest to wait for that =
instead=20
> of trying to code a DLL in VC++.


I'll wait for the .Net side. I've never written in VC++ so any templates =
wouldn't do much for me.


>=20
> << This is my planned intent: I'm going to have a few fields that are=20
> encrypted using Rijndael not by EDB because I need the values =
encrypted when=20
> the EDB Mgr is used @ any given time. The encryption is going to stop =
me=20
> from using any select statements. My thoughts are to use an external =
module=20
> to read the records, decrypt them, validate they need to be in the =
select,=20
> re-encrypt, populate them to a cursor and return the encrypted cursor=20
> accross the network. Assuming the encryption key & SALT would be known =
by=20
> the app & the EDB server. >>
>=20
> Are you wanting to do this every time a SELECT statement is executed, =
or=20
> only have this work with specific stored procedures ?


The data level encryption would only apply to certain fields & certain =
stored procedures. This particular app stores RTF & .DOC(x) files that =
can contain sensitive info so I need to keep them encrypted so even =
admins can't see the content. I'll live with the associated performance =
hit of decrypt, read, validate, encrypt, & 'ship it if it applies' =
logic--- I've not really been able to come up with any other way for =
these fields (yet).

Thanks


jr