Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1213141516»»

Free Encryption Expand / Collapse
Author
Message
Posted Thursday, October 7, 2010 3:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 29, 2011 8:34 AM
Points: 46, Visits: 154
xp_blowfishencrypt and xp_blowfishdecrypt will not work in 64 bit environments.
Please stay away from this encryption method as you may have trouble when migrating to a 64 bit box.

Why not use SQL server encryption?


---------------------------------------------------------------------------------------
It begins by taking the first step.
Post #1000932
Posted Thursday, October 7, 2010 7:07 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
None of the XPs here were distributed as 64 bit. SQL 2000 doesn't have built-in encryption.

Thanks
Mike C
Post #1000981
Posted Friday, October 8, 2010 12:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 5, 2012 2:48 PM
Points: 4, Visits: 13
I am most interested in the base64 encode/decode functions.

The data we are working with is base64 encoded arrays of floating point (32 bit) data. First challenge is to decode large (3-500 kbyte) base64 data strings. The second challenge is to convert the resulting varbinary array into arrays of floats.

Has anyone recompiled the dlls for 64 bit systems (we get the "unable to load dll" error if I try to use the distribution on a current system)? Or are there now a builtin base64 functions?

I have tried using the cast to XML and then calling the XML .value() functions.

DECLARE @data varchar(max), @XmlData xml, @vb varbinary(max)
SET @data = 'SGVsbG8gV29ybGQgIQ=='
SET @XmlData = CAST('<data>' + @data + '</data>' as xml)
SET @vb = @XmlData.value('(data)[1]', 'varbinary(max)')
SELECT @vb, CAST(@vb as varchar(max))

This works for small stirngs, but on large data strings, I get back NULL.

Thanks,

David
Post #1001498
Posted Friday, October 8, 2010 1:25 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
The first issue is probably trying to use the 32-bit dll's on a 64-bit system. Second issue is that binary to float conversion is not supported in SQL...

Ping me offline, I have a solution for you.

Thanks
Mike C
Post #1001558
Posted Friday, October 8, 2010 4:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Better yet, just use the attached script. It has 4 CLR functions that do what you asked.

Enjoy,
Mike C


  Post Attachments 
ClrUtil.zip (50 views, 2.26 KB)
Post #1001653
Posted Monday, December 13, 2010 8:21 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 6:40 AM
Points: 450, Visits: 188
A big thanks for posting this. A client's recent 2000/32 - 2008/64 migration missed an application call to the blowfish dll's and this saved our bacon this morning.




Post #1033839
Posted Thursday, April 28, 2011 3:40 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 7:37 AM
Points: 5, Visits: 62
Hi

Does anyone have an example on how to base64encode and base64decode in SQL 2008 R2?

my code is as follows im using the 64 bit xp_blowfishdecrypt and xp_blowfishencrypt but 32 bit xp_base64encode is there a way around this

....
.....
DECLARE @text VARCHAR(255)

SET @key = '123456789'
EXEC master..xp_base64encode @key, @key OUTPUT
EXEC master..xp_blowfishdecrypt @name, @key, @text OUTPUT
SELECT @text as [Name]



I would really appreciate it if some one can help me on this as im in the process of migrating from SQL 2000 to SQL 2008
Post #1100073
Posted Thursday, May 19, 2011 12:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 12:48 PM
Points: 1, Visits: 3
i have a client who is sending data encrypted in 2005 database. we loaded it into 2008 database appreciate if you could provide dll's for 2008 sql server for 64 bit.
thank you
Post #1111966
Posted Friday, May 20, 2011 5:14 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 7:37 AM
Points: 5, Visits: 62
Go to page 14 of this thread

http://www.sqlservercentral.com/Forums/Topic199534-236-14.aspx

and you will see a zip file attachment from user : cygnussolutions

Thats what i use and they worked fine.

Post #1112267
Posted Saturday, July 16, 2011 7:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 12, 2014 3:20 AM
Points: 2, Visits: 204
Hi

We are currently migrating from SQL 2000 to SQL2008R2 64x and are unable to install the dll's.

Earlier in this thread I have seen the recompiled 64bit versions of the Blowfish implementation - however we use the AES encryption and base64 encoding functionality.

Does anyone have the 64bit version of the AES/base64 related dlls that they can post a link for please?

--

Apologies I mis-posted the above into the wrong thread - we are using the 'SQL 2000 DBA Toolkit' as opposed to the 'SQL Encryption Toolkit' this thread is covering. I will post on that thread instead.

Thanks
Post #1142950
« Prev Topic | Next Topic »

Add to briefcase «««1213141516»»

Permissions Expand / Collapse