Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

ecrypt a db sting to a dll using vs2005 and call it asp

hi,

i have this asp db string

ExecuteMain = "Provider=sqloledb;Data Source=CIB4,1433;Network Library=DBMSSOCN;Initial Catalog=DSDB;User ID=USER;Password=123456;"

i was using a asp to vb to make a dll out of the db string and call it via a asp include page. the include page contains the following asp code.

   Dim artment
   Set artment= Server.CreateObject("DSDBCon.clsDSDBCon")
   strDataSourceName = artment.ExecuteMain
   Set artment= Nothing


how can i do this using visual studio 2005. with this i mean make the dll and and be able to make the call in asp
0
eaweb
Asked:
eaweb
  • 2
1 Solution
 
angus_young_acdcCommented:
Are you using C# as backend code?  If so the following links (to encrypt and decrypt) will give you a good basis to start off how to make your DB connection string more secure.
http://www.codeproject.com/KB/security/DotNetCrypto.aspx
http://www.codeproject.com/KB/vb/VB_NET_TripleDES.aspx?fid=70758&fr=26#xx0xx - Includes VB code

From there would you have a hidden page, or a DLL (class library) which you would be able to call from your backend to encrypt and decrypt the string.

They are of course rather basic methods of encryption, but they should enable you to gain a better understanding and provide the means to increase the encryption level.
0
 
eawebAuthor Commented:
hi i am using vb. i don't quite understand the links you gave me.
i created a new project class library in visual studio 2005 and in there i have written the following:

'================================
Public Class CIB1

    Function ExecuteMain()
        ExecuteMain = "Provider=sqloledb;Data Source=CURCIB3,1433;Network Library=DBMSSOCN;Initial Catalog=DSDB;User ID=DSDBUSER;Password=123456;"
    End Function

End Class
'================================

i build it and the dll is made. how can i call the string out of the dll in my classic asp code in order to connect to the db?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now