Calling Encrypt2 function from Sqlserver select query

[Udit Handa]

I use a database that has user names stored in Encrypted format using
the following API.

Declare Sub Encrypt2 Lib "QPRO32.DLL" (ByVal Work As String, ByVal
PASSWORD As String)

Every time i require the user name i have to again decrypt the name
using the same function.

My problem is that when i fetch a large number of records i have to
loop through every record and call the encrypt function for each
record.Instead of binding the recordset to my control i need to loop
through and fill my control
A MSHFlexGrid in Vb6.0.

Is there a way out to this problem that will make my record populatiog
faster withoutout changing the current Encrypted users.

Thanx in Advance

[Simon Hayes]

"Udit Handa" <ud********@hotmail.com> wrote in message
news:82*************************@posting.google.co m...

I use a database that has user names stored in Encrypted format using
the following API.

Declare Sub Encrypt2 Lib "QPRO32.DLL" (ByVal Work As String, ByVal
PASSWORD As String)

Every time i require the user name i have to again decrypt the name
using the same function.

My problem is that when i fetch a large number of records i have to
loop through every record and call the encrypt function for each
record.Instead of binding the recordset to my control i need to loop
through and fill my control
A MSHFlexGrid in Vb6.0.

Is there a way out to this problem that will make my record populatiog
faster withoutout changing the current Encrypted users.

Thanx in Advance

From a server perspective, you could consider writing an extended stored
procedure to decrypt more than one user name and return them all in a result
set. (Or wait for MSSQL 2005 and write a stored proc using the .NET CLR to
do the same thing.) Although then you'd probably want to encrypt the network
traffic to the client, to prevent the unencrpyted user names going over the
network. If that doesn't help, I suspect you'll get better suggestions in a
VB or client-side forum as to how to process your grid most efficiently.

Simon

[David Portas]

Depends on your reasons for using encryption. Assuming your database is
in a physically secure location then network protocol encryption will
be adequate for many applications. For the rest there are third party
applications and you can Google for those.

--
David Portas
SQL Server MVP
--