Oliver Marx writes:
Well, do you know of a working DA for MSSQL for windows which works? ;) I the adapter was Open Source we would go a fix the bug - but it isn't! egenix is coding on a ODBC DA AWS but they will release it under a commercial license - which is ok - but not perfect in this case. Fortunately, I only rarely need to work with MS products.
When you work under Windows, then there is ZmxODBCDA, a DA on top of "egenix" (yes commercial) mxODBC. I do not know whether it does have your problem, but I expect it will not. This is not the "mxODBCDA", now under development by egenix. When I need to interface with MSSQL (I am then on a Unix plattform), I use either SQLRelay or the SybaseDA both over FreeTDS. I did not yet met a "Missing.Value". This does not necessarily mean, there is none.
We are working for a goverment agency and they *want* a Open Source solution. The "egenix" software *IS* open source, just not without costs.
Dieter