Post reply

Error When Using the Blowfish User Defined Functions

  • January 16, 2006 at 3:18 pm

    #188912

    Has Anyone Encountered This Error When Using the Blowfish User Defined Functions?

    [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()).

    Server: Msg 11, Level 16, State 1, Line 0

    General network error. Check your network documentation.

    Connection Broken

     

    We have a table with approx 1 million credit card number.  A stored procedure first tries to encrypt them and update the creditcardencrypted field with these values.  Next, decrypt the encrypted values and store in creditcarddecrypted field.  Finally, compare the decreypted values with the original credit card numbers.  If success, then update the credit card number to NULL.

     

    This works fine for small data sets, but we're getting the connection error above for anything larger than 700,000 rows.

     

    We're running SQL 2000  SP 3 on Windows 2003 Server.

     

    All help appreciated!

  • February 10, 2006 at 6:00 pm

    #620305

    There was a "memory fragmentation" issue with the prior version.  The memory was being released properly in C++, but SQL Server was not reclaiming it in a timely manner.  I've modified the code to fix this particular issue, and have tested it pretty extensively on several tables with 3,000,000 - 5,000,000 rows each.  The newer version is marked v. 0.9 and has been uploaded to SQL Server Central for download.

    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply