ODBC Hell

Well…The Microsoft SQL Server Migration Assistant, sure does a good job in upgrading an existing MS Access db/application, linking the newly created SQL Server tables and then using the existing UI.

BUT… I’ve stumbled onto a very interesting scenario, where I get a ODBC – Call Failed error every time I try to run a specific query. What was very weird for me, was the fact that I did not get this error on my laptop, running Windows Vista, that was about the only difference between the laptop and the client machine I was converting the db on.

Sooo…after an exhaustive search, I’ve finally stumbled on a newsgroup post, where someone mentioned that you cannot use the = operator with ODBC and SQL2005 but rather LIKE, this is only the fact on certain joins. And hey presto! It works…go figure.

Ok, so that was a pretty big "What I’ve learned this week" , considering how long it took to get working. I counts for 2, here’s the rest

1. Subsonic, a website generation tool.
2. Ironspeed, generates data driven web apps. (Thanks Renier, for these 2)
3. Codekeep, a cool util that integrates with you VS IDE, it allows you to save your code snippets and share it online and access it anywhere.
4. and 5. The horrible SQL 2005/ODBC quagmire.

That’s it for this week. This was also my last week at SDT. Thanks to all the folks in the SWS team! ‘Till Later.