In this article, Dan Lesandrini shows you how to connect to a SQL Server database using ADO and Visual Basic.
All code is documented and provided.
ASP Today John Tabernik urges that it's easier to make changes to your site if most everything is centralized. It is built so that the code can be moved to other Web sites and used as an admin page with few code changes. In forum style, application security via application roles using SQL Server is addressed. Developers interested in permitting users access through a Website and not onto the server may scan the programming detailed here. Generate full-featured and fully customizable ASP database applications for SQL Server or MS Access online with their ASP Generator.