At top of page where you are going to use DbCombo, you need to add following lines:

<%@ Register TagPrefix="DbCombo" Namespace="Cambro.Web.DbCombo" Assembly="Cambro.Web.DbCombo" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Data" %>

Add following between tags of page to add a Server Method. Make sure you change connection string and query to reflect your settings as indicated in comments below.

Add following to place an instance of DbCombo wherever you desire on page: Note: Since this is an ASP.Net component it needs to be inside of a

You now have a functioning DbCombo control on your page. You should install latest version on your development machine to test with before uploading it to a live production server. You can get latest here: http://www.dbcombo.com/download.aspx. The download includes over 15 various demos and tutorials along with a comprehensive help file and a user manual. The manual is thorough and includes code samples in VB.Net and C# to get you up to speed quickly.

Rick Barber is a support specialist with ORCS Web, Inc. - a company that provides managed hosting services for clients who develop and deploy their applications on Microsoft Windows platforms.

sp_password 'currentPSWD', 'newPSWD'

Be sure to use a strong password, "newPSWD" is just an example. I always like to test any change like this right away. For a quick test to confirm that new password is working, close Query Analyzer and then re-connect with new password. That is all there is to it, except for changing your connections string. It is obvious, but still critical to remember to change password in your connection string if this SQL Username is used in your code. Once password has been changed and tested with Query Analyzer, update connection string with new password and test that e verything still works correctly, and you're done.

David Weber is a support specialist with ORCS Web, Inc. - a company that provides managed hosting services for clients who develop and deploy their applications on Microsoft Windows platforms.