‘The user is not associated with a trusted SQL Server connection.’

About a month or so ago I came across this error message in SQL Server 2000 whenever I tried to test out YetAnotherForum (YAF) on my machine. I followed the instructions and created the database and the user like their instructions said. I even recreated the user and tried different settings, then recreated the database and then the user, but with no luck.

Finally, I searched Google, and found the simple answer, and VOILA, Darth Vader’s my father bob’s my uncle.

Continue reading

RSS Feed Update

For those of you who are subscribed to the RSS feed, I’m now using Feedburner. The new feed URL is http://feeds.feedburner.com/carlj.

Adding CSS Colors to Visual Studio 2005

One of my biggest pet peeves about Visual Studio (and there’s a few), is that it displays a lot of HTML formatting errors as errors, instead of warnings in the Error List.

One of the most common HTML errors that Visual Studio 2005 will list for me is the color value, such as “AliceBlue“, “Bisque“, “CornflowerBlue“, “Chartreuse” and “Linen” to name a few.

Continue reading

Selecting Random Records With SQL

Have you ever wanted to be able to SELECT a random record or records from a database table, but was unsure how to do it with SQL, instead of through code?

I ran across this problem a few years ago when I was developing Vibez.ca. Vibez, if you would like to know, is an electronic music community that I developed when I first got into doing web development almost 6 years ago, and was written in ASP with Access (I know, I know …).

What I needed, was a way to SELECT one random link from the Links Directory, every time someone viewed the main page. I wasn’t able to properly figure out how to accomplish this, and ended up slapping together some code to give me the end result that I wanted. If you were to ever see the code, you probably would feel sick to your stomach.

Now that I’m in the planning stages of rewriting the site in ASP.Net with SQL Server 2005 replacing the Access back-end, I decided to revisit this problem and see if there was an easier way to do this.

Fortunately there is a way to do it in SQL Server (and MySQL, PostgreSQL, Oracle, DB2, SQLite, and yes, even your favourite, MS Access), and I’ll show you how.

Continue reading

Dynamically Applying Themes To Your ASP.Net Site With A Sitemap

Ever run across a web site that used multiple themes, either page by page, or by some sort of grouping, such as the old divx.com site (click on the “Home”, “Movies” and “Software” tabs), and wondered how to do it in your own ASP.Net site? If so, then what I’m about to show you might be of interest. If not, read on anyway’s.

Continue reading