Data source name not found
I was trying to install a connector on Windows 2008 64bit and kept receiving an error that it couldn't find the DSN that I had already created. After some searching I found the following:
In a 64 bit windows server operating system, there are TWO odbc managers. When you pull up the usual menu for the odbc / dsn system, it is for the 64 bit odbc manager, and 32 bit applications (vb 6.0) will not work using these dsn's.
This is where the 32 bit odbc manager is:
Hopefully this will help others that run in to this same issue.