> > Without very much hope, trying ODBCng rev 64 from
> > http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer.msi.
> > Setup is OK and <Test> button works. However trying to connect to the
> > database gives "General SQL error. [Microsoft][ODBC Driver Manager] Driver
> > does not support this function".
>
> I seriously doubt that ODBCng is going to work for you. I didn't see
> that you are running 7.x of PostgreSQL. We explicitly do NOT support any
> version less then 8.x of PostgreSQL.
I am *NOT* running v7, except insofar as I'm trying to migrate from a v7 server
to v8. After the work I put into describing what client drivers I was using,
which server I was testing against and what happened I really think that you
could have read my posting without jumping to conclusions.
Where I tested drivers against v7 it was purely to test that the basic
installation was complete, and in most cases it was a known-good v7 driver
against a known-good v7 server. You'd be entitled to criticise me if I hadn't
checked whether my test system still had working ODBC and I'd led everybody on a
wild goose chase as a result. Where I was cross-testing it was out of prurient
curiosity :-)
I suspect that both driver series- i.e. "official" ODBC and ODBCng- are up
against problems with the version of the ODBC DLLs they are expecting.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]