Using DacSession to access data via ODBCDBE

[rdonnay]

:ExecuteQuery() and :ExecuteStatement() are not implemented in Xbase++.

I used SQL cStatement (from sqlcmd.ch).

ODBCDBE docs are confusing.

There are many ambiguities and redundancies in the settings and the commands in SQLCMD.CH.
You can use dbInfo(), dbeInfo() or oSession:setProperty().

I am adding a whole new section to SqlQuery.Prg to help work with these settings on an ODBC connection.

Basically, it appears that dbInfo() and dbeInfo() are the DEFAULT settings which are overridden by oSession:setProperty().

Regardless of all this confusion, I have had great success using the ODBCDBE with Sql Server.
I helped convert a FoxPro project that was written entirely using SQL Server and many stored procedures.