July 2006 Entries
Use the Collection Manager to enable/disable which html help collections are available to your Visual Studio IDE (dynamic help etc). For VS.NET 2003 use: ms-help://MS.VSCC.2003/VSCC... For VS2005 use: ms-help://MS.VSCC.v80/dv_vs... For more info see the FAQ at the Helpware Group's web site. HTH Tim...
XPath statements are case sensitive. To get around this use the following example to convert all data to lower case before performing the equality check: /bookstore/book[translate(@... 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') = '" + searchtext.ToLower() + "'] Thanks very much to Harish for this
When trying to add a diagram to an SQL Server 2005 db I got the following error:Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. I tried the suggestion mentioned in the message but that didnt work. Also found that SQL Server Management Studio...
This error can occur when an application performs a web request to a web app that's trying to interogate the Request.UserAgent - but the requesting app has not set the user agent in the request. To resolve either set the user agent before sending the request eg: HttpWebRequest req = (HttpWebRequest) HttpWebRequest.Create(theUr... (compatible; MSIE 6.0; Windows NT 5.1)"; Alternatively, and preferrably (if you have access to it), fix the server side web application to check...