Run tests in odbc mode

[annaswims]

I haven't successfully set up odbc mode on my machine yet. If someone could run the tests in odbc mode I'd be grateful.

[KDGundermann]

Hi Anna, I would prefer that we will drop the odbc mode, as the odbc code is, hmm, "difficult"

[annaswims]

ODBC is occasionally quite useful, so I won't be dropping it. I used it a few weeks ago for rmre (models reverse engineering). I finally got it set up on my machine and ran the tests and it wasn't that bad. Just a few encoding issues. https://gist.github.com/annaswims/c79c4c10fe951f2673ea

[metaskills]

Up to you, ODBC is slow and the ruby gem has no open presence since last I looked. It also did not do native Ruby data types conversions which added to the speed issue. IMHO, TinyTDS is so much faster and cleaner. There seems to be some great work being done on it too.

[annaswims]

I agree that TDS is the way forward and the obvious first choice, but considering that ODBC is (mostly) working I'd like to just leave it alone for now. I benefited greatly from ODBC in the past month when I used it for rmre (essentially a one-time script) and then switched right back to using TDS.

[metaskills]

Kewl, unless something that pops up that considerable takes it out of the running, I would just continue to document the tests that can not pass under ODBC. In the past, these were mostly date time cast issues.