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.