ODBC Hell

Pieter van der Westhuizen, a professional freelance web & mobile developer and founder of Coalition Software.
Search for a command to run...

Pieter van der Westhuizen, a professional freelance web & mobile developer and founder of Coalition Software.
A recent requirement came up for configurable dynamic forms in a mobile application. There are a few dynamic form packages for Flutter, but I wanted a bit more control over the schema and behavior of the form. Here follows my attempt at creating dyna...

If you've ever written a mobile app with Flutter that integrates with an API, then you'll know that there are a lot of model objects that get passed between the app and the API. JSON Serialization in Flutter can also take a fair amount of boilerplate...

Back in May 2020, Microsoft announced a new feature for Azure Blob Storage called Blob Index. Essentially, this enables you to add key/value tags to your Blob objects and be able to query said Blob objects without having to use a separate service lik...

In my last post, "Using AWS Cognito with Xamarin Forms", I showed how to authenticate with Amazon Cognito using Xamarin Forms and the Xamarin.Essentials Web Authenticator. In this post, we'll go through the process of using the AWS Cognito Hosted UI ...

In this post, I'll show you how to quickly and easily set up user authentication for your Xamarin Forms app using Amazon Cognito. AWS Cognito is a user identity management solution by Amazon. It is a really easy way to add authentication to your appl...

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