A few days back I was trying to troubleshoot a Microsoft Access 2013 project. This project was using the FirebirdSQL database engine as its storage medium with MS Access as the front-end. Typical stuff, nothing really crazy.
However a problem surfaced when trying to deploy to production. I simply could not get the database to connect properly. All Access was able to offer was “ODBC Call failed” yeah thanks. >_>
Pulling out my Windows Web Hosting hat from years ago I tried to remember how I troubleshot connections to MS SQL Databases and DSNs. I enabled ODBC call tracing and pointed it to a file on my desktop and tried connecting again.
From the log file I was able to more accurately understand what was going on. At first I saw a password/incorrect issue, then a Table Rights Issue, then a DLL error. Could not find client library. Huh? The Firebird ODBC DSN connection specifies the Client Library, so why would it error on that?
Eventually after a few days of perusing old StackOverflow questions I stumbled onto why I was having an issue. When I linked my database tables to Access, Access copied some additional connection information into the Connection String entry for that Database Object. This included my development locations for DLLs.
Using some VBA I was able to update the Connection String to using the DSN name only. Not after trying to setup for a DSN-less connection, I have yet to figure out how to bundle all the appropriate libraries etc for production use. The project is client specific, so I wont bother trying to make an installer of sorts.
Moral of the story: Update your DSNs and inspect them for sane information.
Lately I’ve been working with Dropwizard, Amazon Dynamo DB, and Heroku to create a MachineSounds API. I finally got my API target working decently.
Where did I put that 32 gigabytes?
Mockup for my troubleshooting app i’m building on Android. Planning on a type of video feed, a waterfall spectrogram, a map, and the OBDII data from a car.
I cant, for the life of me figure out why I cant get the OpenCV libraries working in a little test project for Android Studio. http://stackoverflow.com/questions/16626878/android-studio-and-gradle-dependency-integration/17368562#comment25897449_17368562
This whole situation kinda reminds me of this blog post about programmers getting stuck. http://www.jeffwofford.com/?p=835 In this current situation, its not for a client, but I am motivated to get my little project going. Ay.
Some days I just want to be dark.