Using DacSession to access data via ODBCDBE

Xbase++ 2.0 Build 554 or later
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Using DacSession to access data via ODBCDBE

#11 Post by 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.
The eXpress train is coming - and it has more cars.

Post Reply