32 bit DSN on 64 bit Windows
Earlier in the week I came across something which had me stumped for a while. After a lot of training on the Endeca platform I finally had an opportunity to set up an instance for a new site. Unfortunately it was a duplication of an existing site so there wasn't that much to do.
Still, I got the tweaked version running on my dev box with no trouble. When I moved it to the staging server it wouldn't work. It consistently failed to connect to the database via a DSN, though the JDBC connection used elsewhere in the configuration worked fine. I checked and double checked the DSN; it worked, no problems. I renamed it, removed and reset it, set it as a user DSN rather than a system DSN, to no avail.
Then I remembered that it's a 64 bit machine, which has bitten me before with an incorrect TortoiseSVN install. After a lot of reading I discovered this relevant Microsoft Knowledge Base article.
The 32 bit version of ODBC administrator is available on 64 bit machines, you just have to go looking for it. So I set up a 32 bit DSN and Endeca ran without a hitch.