morke Newbie Poster

I currently have a database in MS SQL2008 which is accessed via a VB2008 app on a Local Area network. The password for the database is hardcoded within app.config file in the program. However I want to transfer the database out to the web. To that end I have set up virtual server to host the database and transferred a copy of the database with some dummy data to the site. I have written an ASP 3.5 app to login to that test database. The ASP app lets me have a secure user login via authentication within the web.config file. (SHA1). Works fine and brings me back a selection of records to a gridview. I can also make the connection from the VB2008 LAN app. However, I can not figure out how to make a secure connection as is the case with the ASP program. Note: the VB2008 type app is required as it has a large number of modules for speedy data entry, etc. which will not be incorporated wtihin the webb app.

Anyone any ideas.



' ****
' Button clicked so carry out the event
' ****
Private Sub btnEvents_Click(ByVal sender As System.Object, ByVal e As EventArgs) Handles MyBase.Click
Dim cString As String = sender.Text()
'Dim myObject As Object = sender

    Select Case cString
        Case "Add"


morke Newbie Poster

Michael O'Rourke