I do not have a good suggestion on how to determine the odbc lib path BUT you could search $PATH which normally contains the Windows path in Unix format (i.e. "/" rather than "\"). You could just convert $SystemRoot and convert the path
We probably need 64 bit detection logic too. Current cygwin versions are 32 bit so the path would need to be %systemdrive%\Windows\SysWoW64 for 32 bit cygwin under 64 bit Windows - yes the 32 bit path is named 64! :-)
Ug, closing this pull request for now as I wound up having to switch to pyodbc on a native Windows Python install. Had some driver issues that I don't have time to troubleshoot right now - but I'll be back! This is a great project, thanks for the work!