?
Solved

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

Posted on 2008-10-08
5
Medium Priority
?
195 Views
Last Modified: 2013-11-26
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
Comment
Question by:eaweb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 15

Expert Comment

by:angus_young_acdc
ID: 22668984
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
 

Author Comment

by:eaweb
ID: 22672980
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
 
LVL 15

Accepted Solution

by:
angus_young_acdc earned 2000 total points
ID: 22677830
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question