Post reply

[Shared Memory]ConnectionCheckForData Error Using Blowfish Routines

  • January 16, 2006 at 2:55 pm

    #167130

    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:01 pm

    #620306

    Hi Elizabeth,

    Per our emails, this issue (memory fragmentation) has been resolved.  The newer version (v. 0.9) is available for general download on SQL Server Central.  Thanks for bringing this to my attention and helping me test it.

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

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