Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-10-08
5
Medium Priority
?
197 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

604 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