how to create a secure connection string...

[email protected] · May 11th, 2006, 06:12 AM

hi all....

I got a little tricky problem & i am sure there would be more than one buddies who will be able to sort it out...........

i want to creat a connection string that must consists of user name, password and i don't want any buddy to c my database(access db and password protected) on the isp by anyone ....

please use your iq to understand what i really meant....

thanks in advance.....

Abdul Ghaffar

jbenson001 · May 11th, 2006, 01:11 PM

use the web.config to store the connection string.

[email protected] · May 17th, 2006, 12:40 AM

Thanks JB....

Well i have to hard code the password and user name for the connection string in web.config also.......this will reaveal my password protected database to the isp's personals.........is there a way to encrypt the user name and password so that no buddy could able to c my database .........

Abdul Ghaffar

bijgupt · May 18th, 2006, 05:51 AM

U can use password encription.
Set PasswordFormat property to MD5 or SHA . Get encripted password from the fuction GetHashCodeForStoringInWebConfigFile(<password to be encripted>,<MD5 or SHA)

Bijgupt