FreeTDS Development Group

[Gregg Jensen <greggj AT savvis.net>]

In regards to the note I sent out last week about adding the code to
dblib to allow the user to use an environment variable (DBLIB_VERSION),
to control the protocol version during a dbopen call, the changes have
been committed.    The changes went into include/sybdb.h and
src/dblib/dblib.c.  It would be best to do a make clean before building
the library, since there were structure changes.

With these additions it is now possible to use the dbsetversion to set
the protocol for a session.  Or, if you have third party software that
uses dbsetversion and you don't want to change their code (or can't),
then before the dbopen call, you can set the environment variable
DBLIB_VERSION to the appropriate value for the version of the protocol
you want to use, and then the dbproc that is returned will use that
version.  Inside the dbopen, a check is made to the environment
variable, and if it is set, it will use it over what was set in
dbsetversion or the default value (NOTE: it doesn't change the original
value).

This way you can call dbopen to a Sybase database, which will return a
pointer to a DBPROCESS (say dbproc1), and then turn around and set the
environment variable, call dbopen again and get dbproc2.  Now, you can
send a SQL statement to dproc1 get the result values and put them into a
SQL statement for dbproc2.

Gregg Jensen