473,320 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Protecting .net dll's in Sql Server

dear friends

optimistically I'll suicide this weekend or my eyes going blind with sql exception's RED color;

my problem is :
I want to encrypt some of my columns in database and use "decryption.dll" to decrypt them.
the important point is I have to obfuscate the "hash key" string;

my problemS:
1.the CLR dose not support obfuscated dlls;

2.I tried to use assembly class to open decryption.dll and invoke those methods in other class library , but assembly loading is not permitted by CLR

3.I tried to use ObjectHandle class to Load the decryption.dll but I found the strange security permission exception , and "Larry Page" did not help me with his website.

4.I tried to add new class library and add reference to "decryption.dll" but the redline appears like : "which is not present in the current database ....."


Now , Please just help me to find a solution to Protect My "hash key".

thank you.
Mironline
Jan 24 '09 #1
3 2342
ck9663
2,878 Expert 2GB
Would this work? You can use it and create a function. Let the key be inside your function and just return T or F if it's properly decrypted. You can ENCRYPT the code by using the WITH ENCRYPTION during the creation of your function.

Just an option....

-- CK
Jan 25 '09 #2
dear ck9663
thank you for your replay,

my application will install on client servers.
your solution just support "IsEqual" method , and I can do it in application like this :

Expand|Select|Wrap|Line Numbers
  1. select * from [table] where password = 'ckmbniwyr872tasdbcu34'
but I am looking for code like this

Expand|Select|Wrap|Line Numbers
  1. select * from [table] where dbo.decodeMethod.contain(firstname,'lwjdf3982acxkjh') = true
thank you.
mironline
Jan 25 '09 #3
ck9663
2,878 Expert 2GB
I think that would be a .Net question. Have you tried posting this question in .Net forum?

-- CK
Jan 26 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

22
by: Harold Crump | last post by:
Greetings, I have a PHP/MySQL application that I am deploying at a client's. I am fairly certain that they will steal my source code and re-sell to other companies. I would like to somehow...
12
by: Roland Hall | last post by:
I read Aaron's article: http://www.aspfaq.com/show.asp?id=2276 re: protecting images from linked to by other sites. There is a link at the bottom of that page that references an interesting...
5
by: John | last post by:
Dear all, I've got a security question that is so difficult that "maybe" there will be no answer for it. It's regarding protecting asp code. I did write some asp code, that I sell to...
7
by: Shawn | last post by:
Hi. I have a folder that contains a lot of different documents. xls, .doc, .pdf etc. Different users have access to different documents. The problem is that if a user knows the name of a...
9
by: Lucas | last post by:
Hi, I have an ASP.Net application and I'd like to know about how to protect it from Software Piracy. Are there some alternatives to do that? Thanks a lot LucasC
2
by: Ryan Moore | last post by:
I am creating a site that has an "Uploads" directory where users can upload image files (let's say .jpgs and .gifs). When a user uploads an image, the system creates a directory within this...
3
by: Mike Kingscott | last post by:
Hi there, I'm writing an app in which a punter buys some PDFs online. After purchasing said PDFs, they will be given a token (bless them Guids) to go to a download .ASPX page from which they can...
4
by: Bill K | last post by:
Hello All, I've finally written an asp app that is worthy of resale and would like to hear from you who have done the same. What is the best way to protect my application? I would like to stay...
1
by: =?Utf-8?B?S2xhdXMgSmVuc2Vu?= | last post by:
Hi I have in the past had succes with protecting pdf-files from download by unauthenticated users by adding an application extension in IIS and mapping pdf.files to be served by the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.