Hello all,
There is a new odbc driver (version 6.30.0237) and source code at our
website (http://www.insightdist.com/psqlodbc). This one contains some
bug fixes AND alot of setup options! You can now configure the driver
more closely to match your needs hopefully. Please click on the version
link and/or the "dialog boxes" link for more detailed information. Some
quick highlights are:
- By democratic vote, uses ISO datestyle, period! Automatically sets
this datestyle to backend on connection.
- Advanced options for Driver and Datasource (and lots of them).
- Ability to control whether cursors are used, thus emulating the old
driver/libpq behavior.
- Ability to control how unknown sizes are reported: "Longest" emulates
old driver/libpq behavior.
- Recognizing Unique indexes is a driver option.
- Some data type mappings and data type sizes are configurable.
- SQLExtendedFetch implemented when not using cursors.
There is also a "Defaults" button to set all these options back to
optimum settings.
Note, there are performance issues involved with not using cursors,
since the driver must suck down all the rows in the result set.
However, there are some advantages when it comes to updating tables
since the tables are not kept locked by the backend. If you are having
problems with locked tables or the driver hanging, try setting Use
Cursors to false. This is a workaround until whenever the backend
locking improves. Also, when not using cursors, the sizes of character
data types varchar and text can be known since all the tuples are
retrieved in the result set. So if you set the option "Longest" on the
Advanced Options (Driver), this will be possible.
Feedback on this new driver is appreciated.
Regards,
Byron.