The Archives

• 01.09.08
  ‘The user is not associated with a trusted SQL Server connection.’
  SQL, Uncategorized (5)

  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...
  
  
• 12.16.07
  Selecting Random Records With SQL
  SQL (45)

  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, ...