MySQL Connector/ODBC 3.51.14 is available!

Dear MySQL users,

MySQL Connector/ODBC 3.51.14, a new version of the ODBC driver for the
MySQL database system, has been released. This release is the latest
release of the 3.51 series and is suitable for use with any MySQL
version including MySQL 4.1, 5.0, or 5.1.

WARNING

While we consider this a production release, we recommend caution in
upgrading due to changes in our build procedures, and the large number
of bug fixes that have gone into this long-delayed release.

The release is now available in source and binary form for a number of
platforms from our download pages at

http://dev.mysql.com/downloads/connector/odbc/3.51.html

and mirror sites. Note that not all mirror sites may be up to date at this
point in time, so if you can't find this version on some mirror, please try
again later or choose another download site.

Jess Balint and others from MySQL will be speaking about ODBC at our
MySQL Conference & Expo in late April, in a talk titled "Primetime ODBC:
Constructing ODBC Applications and the ODBC 5.0 Roadmap." Early
registration for the conference closes on March 14, 2007, so register
now to save $200!

http://www.mysqlconf.com/

We welcome and appreciate your feedback, bug reports, bug fixes, patches, etc.:

http://forge.mysql.com/wiki/Contributing

Platform notes:
* There are no binary packages for Microsoft Windows x64 Edition --
these will be provided in a future release.
* The RPM binary packages do not include the GUI bits.
* The Mac OS X binary packages are only provided as tarballs, there is no
installer for this release.
* There is no binary package for Mac OS X on 64-bit PowerPC because Apple
does not currently provide a 64-bit PowerPC version of iODBC.
* The HP-UX 11.23 IA64 binary package does not include the GUI bits because
of problems building Qt on that platform.
* The binary packages for Sun Solaris are only provided as tarballs, not
the PKG format, for this release.
* There are no binary packages for SCO OpenServer.

Changes since the last release:

Functionality added or changed:
* Added auto-reconnect option because automatic reconnect is now
disabled by default in libmysql
* Added auto is null option (Bug #10910)
* Added support for SQLMoreResults
* Checking SQL_ATTR_CONNECTION_DEAD now always calls mysql_ping() to
check for a dead connection.
* Remove ODBC escape syntax { and } that begin and terminate statements,
allowing {CALL (?)} for procedures that don't require OUT or INOUT
parameters
* Improved regression tests
* Added --with-separate-debug-driver ./configure option

Bugs fixed:
* SQL_ATTR_CONNECTION_TIMEOUT was inappropriately mapped to
MYSQL_OPT_CONNECT_TIMEOUT. (Bug #19823)
* Prepared statements using the embedded MySQL server would fail
due to an unitialized variable. (Bug #16535)
* Fix positioned update and delete on statements derived from one
table with no primary key but including all columns (Bug #22796)
* Only initialize the ODBC version when the old-style SQLAllocEnv()
is called. If SQLAllocHandle() is used, the ODBC version must be
explicitly specified using a call to SQLSetEnvAttr()
* On 64-bit systems, some types would be incorrectly returned. (Bug #26024)
* Using DataAdapter, Connector/ODBC may continually consume memory when
reading the same records within a loop (Windows Server 2003 SP1/SP2 only).
(Bug #20459)
* Fix truncation of queries with leading spaces when SQL_ATTR_MAX_ROWS
is set to a non-zero value (Bug #6609)
* Fixed problem with memory allocation in Windows for BLOB and long
queries that need re-allocation of net->buff
* Using Connector/ODBC, with SQLBindCol and binding the length to the return
value from SQL_LEN_DATA_AT_EXEC fails with a memory allocation error.
(Bug #20547)
* Fixed Windows-specific problems with the GUI for SQL_DRIVER_PROMPT
* Fixed issues with numeric and decimal rounding
* Fixed memory leak in SQLDriverConnect()
* Fixed serious memory leak in SQLSpecialColumns() (up to 8KB/call)
* Fixed handle leak in LibMain (Bug #21385, thanks to Leandro Becker)
* Fixed field lengths reported by SQLDescribeCol() when using functions
such as COMPRESS() in SELECT queries (Bug #20208)
* Fixed 64-bit issues related to SQLINTEGER columns defined as int,
but later cast to long.
* TIME fields were incorrectly converted into date/time values. (Bug #25846,
Bug #24867, and Bug #25432)
* Fixed #Deleted issue in Microsoft Access by changing the default behavior
of MyODBC driver regarding SQL_AUTO_IS_NULL variable. Added new option to
the GUI and driver
* Fixed memory leak in SQLSpecialColumns()
* Corrected return size of SQLGetStmtAttr() when getting desc handles
* Fixed SQLGetInfo() of SQL_TXN_CAPABLE to return SQL_TC_DDL_COMMIT
* For SQL_C_TIME, handle conversion from the different time-related MySQL
types, instead of always assuming it is just a TIME. (DATETIME, TIMESTAMP,
and DATE were all handled incorrectly.)
* Fix crash when default database is not set
* Fix handling of lost connections (Bug #14639)
* File DSNs could not be saved. (Bug #12019)
* Nullability of auto_increment fields is incorrect. (Bug #10130)
* Connector/ODBC may insert the wrong parameter values when using prepared
statements under 64-bit Linux. (Bug #22446)
* The SQLDriverConnect() ODBC method did not work with recent Connector/ODBC
releases. (Bug #12393)
* Some properties returned by SQLGetInfo() were set using the wrong data
type, resulting in possible memory overruns. (Bug #20995)
* Ending a transaction using SQLEndTran() on a environment handle was
not supported. (Bug #21588)

Enjoy!

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL Connector/ODBC 3.51.14 is available!

------=_Part_19061_19266892.1173800782957
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64
Content-Disposition: inline

SGVsbG8sCgpUaGFua3MgZm9yIHRoaXMgcmVsZWFzZSAhIQoKTXkgb25seSBx dWVzdGlvbiBpczog
aXMgdGhpcyByZWxlYXNlIHN0YWJsZSBlbm91Z2ggdG8gYmUgdXNlZCBvbiBM aW51eC02ND8KT3Ig
bm90PwoKU29tZSB3ZWVrcyBhZ28geW91IHRvbGQgbWUgYSBuZXcgdmVyc2lv biB3YXMgY29taW5n
IHRoYXQgd291bGQgZml4IHRoZQpwcm9ibGVtcyBvbiA2NC1iaXRzLCBidXQg SSBkb24ndCBrbm93
IGlmIHRoaXMgaXMgdGhpcyBvbmUgb3IgYSBsYXRlciBvbmUuCgpUaGFua3MK CkplYW4tTm/Dq2wK
Ck9uIDMvOS8wNywgSmltIFdpbnN0ZWFkIDxqaW13QG15c3FsLmNvbT4gd3Jv dGU6Cj4KPiBEZWFy
IE15U1FMIHVzZXJzLAo+Cj4gTXlTUUwgQ29ubmVjdG9yL09EQkMgMy41MS4x NCwgYSBuZXcgdmVy
c2lvbiBvZiB0aGUgT0RCQyBkcml2ZXIgZm9yIHRoZQo+IE15U1FMIGRhdGFi YXNlIHN5c3RlbSwg
aGFzIGJlZW4gcmVsZWFzZWQuICBUaGlzIHJlbGVhc2UgaXMgdGhlIGxhdGVz dAo+IHJlbGVhc2Ug
b2YgdGhlIDMuNTEgc2VyaWVzIGFuZCBpcyBzdWl0YWJsZSBmb3IgdXNlIHdp dGggYW55IE15U1FM
Cj4gdmVyc2lvbiBpbmNsdWRpbmcgTXlTUUwgNC4xLCA1LjAsIG9yIDUuMS4K Pgo+ICAgV0FSTklO
Rwo+Cj4gICBXaGlsZSB3ZSBjb25zaWRlciB0aGlzIGEgcHJvZHVjdGlvbiBy ZWxlYXNlLCB3ZSBy
ZWNvbW1lbmQgY2F1dGlvbiBpbgo+ICAgdXBncmFkaW5nIGR1ZSB0byBjaGFu Z2VzIGluIG91ciBi
dWlsZCBwcm9jZWR1cmVzLCBhbmQgdGhlIGxhcmdlIG51bWJlcgo+ICAgb2Yg YnVnIGZpeGVzIHRo
YXQgaGF2ZSBnb25lIGludG8gdGhpcyBsb25nLWRlbGF5ZWQgcmVsZWFzZS4K Pgo+IFRoZSByZWxl
YXNlIGlzIG5vdyBhdmFpbGFibGUgaW4gc291cmNlIGFuZCBiaW5hcnkgZm9y bSBmb3IgYSBudW1i
ZXIgb2YKPiBwbGF0Zm9ybXMgZnJvbSBvdXIgZG93bmxvYWQgcGFnZXMgYXQK Pgo+ICAgIGh0dHA6
Ly9kZXYubXlzcWwuY29tL2Rvd25sb2Fkcy9jb25uZWN0b3Ivb2RiYy8zLjUx Lmh0bWwKPgo+IGFu
ZCBtaXJyb3Igc2l0ZXMuIE5vdGUgdGhhdCBub3QgYWxsIG1pcnJvciBzaXRl cyBtYXkgYmUgdXAg
dG8gZGF0ZSBhdCB0aGlzCj4gcG9pbnQgaW4gdGltZSwgc28gaWYgeW91IGNh bid0IGZpbmQgdGhp
cyB2ZXJzaW9uIG9uIHNvbWUgbWlycm9yLCBwbGVhc2UKPiB0cnkKPiBhZ2Fp biBsYXRlciBvciBj
aG9vc2UgYW5vdGhlciBkb3dubG9hZCBzaXRlLgo+Cj4gSmVzcyBCYWxpbnQg YW5kIG90aGVycyBm
cm9tIE15U1FMIHdpbGwgYmUgc3BlYWtpbmcgYWJvdXQgT0RCQyBhdCBvdXIK PiBNeVNRTCBDb25m
ZXJlbmNlICYgRXhwbyBpbiBsYXRlIEFwcmlsLCBpbiBhIHRhbGsgdGl0bGVk ICJQcmltZXRpbWUg
T0RCQzoKPiBDb25zdHJ1Y3RpbmcgT0RCQyBBcHBsaWNhdGlvbnMgYW5kIHRo ZSBPREJDIDUuMCBS
b2FkbWFwLiIgRWFybHkKPiByZWdpc3RyYXRpb24gZm9yIHRoZSBjb25mZXJl bmNlIGNsb3NlcyBv
biBNYXJjaCAxNCwgMjAwNywgc28gcmVnaXN0ZXIKPiBub3cgdG8gc2F2ZSAk MjAwIQo+Cj4gICAg
aHR0cDovL3d3dy5teXNxbGNvbmYuY29tLwo+Cj4gV2Ugd2VsY29tZSBhbmQg YXBwcmVjaWF0ZSB5
b3VyIGZlZWRiYWNrLCBidWcgcmVwb3J0cywgYnVnIGZpeGVzLCBwYXRjaGVz LAo+IGV0Yy46Cj4K
PiAgICBodHRwOi8vZm9yZ2UubXlzcWwuY29tL3dpa2kvQ29udHJpYnV0aW5n Cj4KPiBQbGF0Zm9y
bSBub3RlczoKPiAqIFRoZXJlIGFyZSBubyBiaW5hcnkgcGFja2FnZXMgZm9y IE1pY3Jvc29mdCBX
aW5kb3dzIHg2NCBFZGl0aW9uIC0tCj4gICB0aGVzZSB3aWxsIGJlIHByb3Zp ZGVkIGluIGEgZnV0
dXJlIHJlbGVhc2UuCj4gKiBUaGUgUlBNIGJpbmFyeSBwYWNrYWdlcyBkbyBu b3QgaW5jbHVkZSB0
aGUgR1VJIGJpdHMuCj4gKiBUaGUgTWFjIE9TIFggYmluYXJ5IHBhY2thZ2Vz IGFyZSBvbmx5IHBy
b3ZpZGVkIGFzIHRhcmJhbGxzLCB0aGVyZSBpcyBubwo+ICAgaW5zdGFsbGVy IGZvciB0aGlzIHJl
bGVhc2UuCj4gKiBUaGVyZSBpcyBubyBiaW5hcnkgcGFja2FnZSBmb3IgTWFj IE9TIFggb24gNjQt
Yml0IFBvd2VyUEMgYmVjYXVzZSBBcHBsZQo+ICAgZG9lcyBub3QgY3VycmVu dGx5IHByb3ZpZGUg
YSA2NC1iaXQgUG93ZXJQQyB2ZXJzaW9uIG9mIGlPREJDLgo+ICogVGhlIEhQ LVVYIDExLjIzIElB
NjQgYmluYXJ5IHBhY2thZ2UgZG9lcyBub3QgaW5jbHVkZSB0aGUgR1VJIGJp dHMKPiBiZWNhdXNl
Cj4gICBvZiBwcm9ibGVtcyBidWlsZGluZyBRdCBvbiB0aGF0IHBsYXRmb3Jt Lgo+ICogVGhlIGJp
bmFyeSBwYWNrYWdlcyBmb3IgU3VuIFNvbGFyaXMgYXJlIG9ubHkgcHJvdmlk ZWQgYXMgdGFyYmFs
bHMsIG5vdAo+ICAgdGhlIFBLRyBmb3JtYXQsIGZvciB0aGlzIHJlbGVhc2Uu Cj4gKiBUaGVyZSBh
cmUgbm8gYmluYXJ5IHBhY2thZ2VzIGZvciBTQ08gT3BlblNlcnZlci4KPgo+ IENoYW5nZXMgc2lu
Y2UgdGhlIGxhc3QgcmVsZWFzZToKPgo+ICAgRnVuY3Rpb25hbGl0eSBhZGRl ZCBvciBjaGFuZ2Vk
Ogo+ICAgKiBBZGRlZCBhdXRvLXJlY29ubmVjdCBvcHRpb24gYmVjYXVzZSBh dXRvbWF0aWMgcmVj
b25uZWN0IGlzIG5vdwo+ICAgICBkaXNhYmxlZCBieSBkZWZhdWx0IGluIGxp Ym15c3FsCj4gICAq
IEFkZGVkIGF1dG8gaXMgbnVsbCBvcHRpb24gKEJ1ZyAjMTA5MTApCj4gICAq IEFkZGVkIHN1cHBv
cnQgZm9yIFNRTE1vcmVSZXN1bHRzCj4gICAqIENoZWNraW5nIFNRTF9BVFRS X0NPTk5FQ1RJT05f
REVBRCBub3cgYWx3YXlzIGNhbGxzIG15c3FsX3BpbmcoKSB0bwo+ICAgICBj aGVjayBmb3IgYSBk
ZWFkIGNvbm5lY3Rpb24uCj4gICAqIFJlbW92ZSBPREJDIGVzY2FwZSBzeW50 YXggeyBhbmQgfSB0
aGF0IGJlZ2luIGFuZCB0ZXJtaW5hdGUgc3RhdGVtZW50cywKPiAgICAgYWxs b3dpbmcge0NBTEwg
KD8pfSBmb3IgcHJvY2VkdXJlcyB0aGF0IGRvbid0IHJlcXVpcmUgT1VUIG9y IElOT1VUCj4gICAg
IHBhcmFtZXRlcnMKPiAgICogSW1wcm92ZWQgcmVncmVzc2lvbiB0ZXN0cwo+ ICAgKiBBZGRlZCAt
LXdpdGgtc2VwYXJhdGUtZGVidWctZHJpdmVyIC4vY29uZmlndXJlIG9wdGlv bgo+Cj4gICBCdWdz
IGZpeGVkOgo+ICAgKiBTUUxfQVRUUl9DT05ORUNUSU9OX1RJTUVPVVQgd2Fz IGluYXBwcm9wcmlh
dGVseSBtYXBwZWQgdG8KPiAgICAgTVlTUUxfT1BUX0NPTk5FQ1RfVElNRU9V VC4gKEJ1ZyAjMTk4
MjMpCj4gICAqIFByZXBhcmVkIHN0YXRlbWVudHMgdXNpbmcgdGhlIGVtYmVk ZGVkIE15U1FMIHNl
cnZlciB3b3VsZCBmYWlsCj4gICAgIGR1ZSB0byBhbiB1bml0aWFsaXplZCB2 YXJpYWJsZS4gKEJ1
ZyAjMTY1MzUpCj4gICAqIEZpeCBwb3NpdGlvbmVkIHVwZGF0ZSBhbmQgZGVs ZXRlIG9uIHN0YXRl
bWVudHMgZGVyaXZlZCBmcm9tIG9uZQo+ICAgICB0YWJsZSB3aXRoIG5vIHBy aW1hcnkga2V5IGJ1
dCBpbmNsdWRpbmcgYWxsIGNvbHVtbnMgKEJ1ZyAjMjI3OTYpCj4gICAqIE9u bHkgaW5pdGlhbGl6
ZSB0aGUgT0RCQyB2ZXJzaW9uIHdoZW4gdGhlIG9sZC1zdHlsZSBTUUxBbGxv Y0VudigpCj4gICAg
IGlzIGNhbGxlZC4gSWYgU1FMQWxsb2NIYW5kbGUoKSBpcyB1c2VkLCB0aGUg T0RCQyB2ZXJzaW9u
IG11c3QgYmUKPiAgICAgZXhwbGljaXRseSBzcGVjaWZpZWQgdXNpbmcgYSBj YWxsIHRvIFNRTFNl
dEVudkF0dHIoKQo+ICAgKiBPbiA2NC1iaXQgc3lzdGVtcywgc29tZSB0eXBl cyB3b3VsZCBiZSBp
bmNvcnJlY3RseSByZXR1cm5lZC4gKEJ1Zwo+ICMyNjAyNCkKPiAgICogVXNp bmcgRGF0YUFkYXB0
ZXIsIENvbm5lY3Rvci9PREJDIG1heSBjb250aW51YWxseSBjb25zdW1lIG1l bW9yeSB3aGVuCj4g
ICAgIHJlYWRpbmcgdGhlIHNhbWUgcmVjb3JkcyB3aXRoaW4gYSBsb29wIChX aW5kb3dzIFNlcnZl
ciAyMDAzIFNQMS9TUDIKPiBvbmx5KS4KPiAgICAgKEJ1ZyAjMjA0NTkpCj4g ICAqIEZpeCB0cnVu
Y2F0aW9uIG9mIHF1ZXJpZXMgd2l0aCBsZWFkaW5nIHNwYWNlcyB3aGVuIFNR TF9BVFRSX01BWF9S
T1dTCj4gICAgIGlzIHNldCB0byBhIG5vbi16ZXJvIHZhbHVlIChCdWcgIzY2 MDkpCj4gICAqIEZp
eGVkIHByb2JsZW0gd2l0aCBtZW1vcnkgYWxsb2NhdGlvbiBpbiBXaW5kb3dz IGZvciBCTE9CIGFu
ZCBsb25nCj4gICAgIHF1ZXJpZXMgdGhhdCBuZWVkIHJlLWFsbG9jYXRpb24g b2YgbmV0LT5idWZm
Cj4gICAqIFVzaW5nIENvbm5lY3Rvci9PREJDLCB3aXRoIFNRTEJpbmRDb2wg YW5kIGJpbmRpbmcg
dGhlIGxlbmd0aCB0byB0aGUKPiByZXR1cm4KPiAgICAgdmFsdWUgZnJvbSBT UUxfTEVOX0RBVEFf
QVRfRVhFQyBmYWlscyB3aXRoIGEgbWVtb3J5IGFsbG9jYXRpb24gZXJyb3Iu Cj4gICAgIChCdWcg
IzIwNTQ3KQo+ICAgKiBGaXhlZCBXaW5kb3dzLXNwZWNpZmljIHByb2JsZW1z IHdpdGggdGhlIEdV
SSBmb3IgU1FMX0RSSVZFUl9QUk9NUFQKPiAgICogRml4ZWQgaXNzdWVzIHdp dGggbnVtZXJpYyBh
bmQgZGVjaW1hbCByb3VuZGluZwo+ICAgKiBGaXhlZCBtZW1vcnkgbGVhayBp biBTUUxEcml2ZXJD
b25uZWN0KCkKPiAgICogRml4ZWQgc2VyaW91cyBtZW1vcnkgbGVhayBpbiBT UUxTcGVjaWFsQ29s
dW1ucygpICh1cCB0byA4S0IvY2FsbCkKPiAgICogRml4ZWQgaGFuZGxlIGxl YWsgaW4gTGliTWFp
biAoQnVnICMyMTM4NSwgdGhhbmtzIHRvIExlYW5kcm8gQmVja2VyKQo+ICAg KiBGaXhlZCBmaWVs
ZCBsZW5ndGhzIHJlcG9ydGVkIGJ5IFNRTERlc2NyaWJlQ29sKCkgd2hlbiB1 c2luZyBmdW5jdGlv
bnMKPiAgICAgc3VjaCBhcyBDT01QUkVTUygpIGluIFNFTEVDVCBxdWVyaWVz IChCdWcgIzIwMjA4
KQo+ICAgKiBGaXhlZCA2NC1iaXQgaXNzdWVzIHJlbGF0ZWQgdG8gU1FMSU5U RUdFUiBjb2x1bW5z
IGRlZmluZWQgYXMgaW50LAo+ICAgICBidXQgbGF0ZXIgY2FzdCB0byBsb25n Lgo+ICAgKiBUSU1F
IGZpZWxkcyB3ZXJlIGluY29ycmVjdGx5IGNvbnZlcnRlZCBpbnRvIGRhdGUv dGltZSB2YWx1ZXMu
IChCdWcKPiAjMjU4NDYsCj4gICAgIEJ1ZyAjMjQ4NjcsIGFuZCBCdWcgIzI1 NDMyKQo+ICAgKiBG
aXhlZCAjRGVsZXRlZCBpc3N1ZSBpbiBNaWNyb3NvZnQgQWNjZXNzIGJ5IGNo YW5naW5nIHRoZSBk
ZWZhdWx0Cj4gYmVoYXZpb3IKPiAgICAgb2YgTXlPREJDIGRyaXZlciByZWdh cmRpbmcgU1FMX0FV
VE9fSVNfTlVMTCB2YXJpYWJsZS4gQWRkZWQgbmV3IG9wdGlvbgo+IHRvCj4g ICAgIHRoZSBHVUkg
YW5kIGRyaXZlcgo+ICAgKiBGaXhlZCBtZW1vcnkgbGVhayBpbiBTUUxTcGVj aWFsQ29sdW1ucygp
Cj4gICAqIENvcnJlY3RlZCByZXR1cm4gc2l6ZSBvZiBTUUxHZXRTdG10QXR0 cigpIHdoZW4gZ2V0
dGluZyBkZXNjIGhhbmRsZXMKPiAgICogRml4ZWQgU1FMR2V0SW5mbygpIG9m IFNRTF9UWE5fQ0FQ
QUJMRSB0byByZXR1cm4gU1FMX1RDX0RETF9DT01NSVQKPiAgICogRm9yIFNR TF9DX1RJTUUsIGhh
bmRsZSBjb252ZXJzaW9uIGZyb20gdGhlIGRpZmZlcmVudCB0aW1lLXJlbGF0 ZWQKPiBNeVNRTAo+
ICAgICB0eXBlcywgaW5zdGVhZCBvZiBhbHdheXMgYXNzdW1pbmcgaXQgaXMg anVzdCBhIFRJTUUu
IChEQVRFVElNRSwKPiBUSU1FU1RBTVAsCj4gICAgIGFuZCBEQVRFIHdlcmUg YWxsIGhhbmRsZWQg
aW5jb3JyZWN0bHkuKQo+ICAgKiBGaXggY3Jhc2ggd2hlbiBkZWZhdWx0IGRh dGFiYXNlIGlzIG5v
dCBzZXQKPiAgICogRml4IGhhbmRsaW5nIG9mIGxvc3QgY29ubmVjdGlvbnMg KEJ1ZyAjMTQ2Mzkp
Cj4gICAqIEZpbGUgRFNOcyBjb3VsZCBub3QgYmUgc2F2ZWQuIChCdWcgIzEy MDE5KQo+ICAgKiBO
dWxsYWJpbGl0eSBvZiBhdXRvX2luY3JlbWVudCBmaWVsZHMgaXMgaW5jb3Jy ZWN0LiAoQnVnICMx
MDEzMCkKPiAgICogQ29ubmVjdG9yL09EQkMgbWF5IGluc2VydCB0aGUgd3Jv bmcgcGFyYW1ldGVy
IHZhbHVlcyB3aGVuIHVzaW5nCj4gcHJlcGFyZWQKPiAgICAgc3RhdGVtZW50 cyB1bmRlciA2NC1i
aXQgTGludXguIChCdWcgIzIyNDQ2KQo+ICAgKiBUaGUgU1FMRHJpdmVyQ29u bmVjdCgpIE9EQkMg
bWV0aG9kIGRpZCBub3Qgd29yayB3aXRoIHJlY2VudAo+IENvbm5lY3Rvci9P REJDCj4gICAgIHJl
bGVhc2VzLiAoQnVnICMxMjM5MykKPiAgICogU29tZSBwcm9wZXJ0aWVzIHJl dHVybmVkIGJ5IFNR
TEdldEluZm8oKSB3ZXJlIHNldCB1c2luZyB0aGUgd3JvbmcgZGF0YQo+ICAg ICB0eXBlLCByZXN1
bHRpbmcgaW4gcG9zc2libGUgbWVtb3J5IG92ZXJydW5zLiAoQnVnICMyMDk5 NSkKPiAgICogRW5k
aW5nIGEgdHJhbnNhY3Rpb24gdXNpbmcgU1FMRW5kVHJhbigpIG9uIGEgZW52 aXJvbm1lbnQgaGFu
ZGxlIHdhcwo+ICAgICBub3Qgc3VwcG9ydGVkLiAoQnVnICMyMTU4OCkKPgo+ IEVuam95IQo+Cj4g
LS0KPiBNeVNRTCBPREJDIE1haWxpbmcgTGlzdAo+IEZvciBsaXN0IGFyY2hp dmVzOiBodHRwOi8v
bGlzdHMubXlzcWwuY29tL215b2RiYwo+IFRvIHVuc3Vic2NyaWJlOgo+IGh0 dHA6Ly9saXN0cy5t
eXNxbC5jb20vbXlvZGJjP3Vuc3ViPWVsdmFub3IyMDA3QGdtYWlsLmNvbQo+ Cj4K
------=_Part_19061_19266892.1173800782957--

Re: MySQL Connector/ODBC 3.51.14 is available!

On Tue, Mar 13, 2007 at 04:46:22PM +0100, Jean-Noël Rivasseau wrote:
> Thanks for this release !!
>
> My only question is: is this release stable enough to be used on Linux-64?
> Or not?
>
> Some weeks ago you told me a new version was coming that would fix the
> problems on 64-bits, but I don't know if this is this one or a later one.

All of the 64-bit issues that we knew about should be fixed in 3.51.14.
It's certainly enough to try on 64-bit platforms, but you should
definitely give it a workout before trying to use it in production.

Jim Winstead
MySQL Inc.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL Connector/ODBC 3.51.14 is available!

In the DSN configuration dialog, Advanced page, we can see the
option to enable auto reconnet and its tooltip mentions "it is strongly
not recommended to set this flag for transactional operations!".

Can you shed some light on this subject?
Are there any articles describing case scenarios for transction disaster?

Thank you.
FC


> On Sex Mar 9 22:56 , Jim Winstead sent:Dear MySQL users,

MySQL Connector/ODBC 3.51.14, a new version of the ODBC driver for the
MySQL database system, has been released. This release is the latest
release of the 3.51 series and is suitable for use with any MySQL
version including MySQL 4.1, 5.0, or 5.1.

WARNING

While we consider this a production release, we recommend caution in
upgrading due to changes in our build procedures, and the large number
of bug fixes that have gone into this long-delayed release.

The release is now available in source and binary form for a number of
platforms from our download pages at

http://dev.mysql.com/downloads/connector/odbc/3.51.html

and mirror sites. Note that not all mirror sites may be up to date at this
point in time, so if you can't find this version on some mirror, please try
again later or choose another download site.

Jess Balint and others from MySQL will be speaking about ODBC at our
MySQL Conference & Expo in late April, in a talk titled "Primetime ODBC:
Constructing ODBC Applications and the ODBC 5.0 Roadmap." Early
registration for the conference closes on March 14, 2007, so register
now to save $200!

http://www.mysqlconf.com/

We welcome and appreciate your feedback, bug reports, bug fixes, patches, e=
tc.:

http://forge.mysql.com/wiki/Contributing

Platform notes:
these will be provided in a future release.
installer for this release.
does not currently provide a 64-bit PowerPC version of iODBC.
of problems building Qt on that platform.
the PKG format, for this release.

Changes since the last release:

Functionality added or changed:
* Added auto-reconnect option because automatic reconnect is now
disabled by default in libmysql
* Added auto is null option (Bug #10910)
* Added support for SQLMoreResults
* Checking SQL_ATTR_CONNECTION_DEAD now always calls mysql_ping() to
check for a dead connection.
* Remove ODBC escape syntax { and } that begin and terminate statements,
allowing {CALL (?)} for procedures that don't require OUT or INOUT
parameters
* Improved regression tests
* Added --with-separate-debug-driver ./configure option

Bugs fixed:
* SQL_ATTR_CONNECTION_TIMEOUT was inappropriately mapped to
MYSQL_OPT_CONNECT_TIMEOUT. (Bug #19823)
* Prepared statements using the embedded MySQL server would fail
due to an unitialized variable. (Bug #16535)
* Fix positioned update and delete on statements derived from one
table with no primary key but including all columns (Bug #22796)
* Only initialize the ODBC version when the old-style SQLAllocEnv()
is called. If SQLAllocHandle() is used, the ODBC version must be
explicitly specified using a call to SQLSetEnvAttr()
* On 64-bit systems, some types would be incorrectly returned. (Bug #2602=
4)=20
* Using DataAdapter, Connector/ODBC may continually consume memory when
reading the same records within a loop (Windows Server 2003 SP1/SP2 onl=
y).
(Bug #20459)
* Fix truncation of queries with leading spaces when SQL_ATTR_MAX_ROWS
is set to a non-zero value (Bug #6609)
* Fixed problem with memory allocation in Windows for BLOB and long
queries that need re-allocation of net->buff
* Using Connector/ODBC, with SQLBindCol and binding the length to the ret=
urn
value from SQL_LEN_DATA_AT_EXEC fails with a memory allocation error.
(Bug #20547)
* Fixed Windows-specific problems with the GUI for SQL_DRIVER_PROMPT
* Fixed issues with numeric and decimal rounding
* Fixed memory leak in SQLDriverConnect()
* Fixed serious memory leak in SQLSpecialColumns() (up to 8KB/call)
* Fixed handle leak in LibMain (Bug #21385, thanks to Leandro Becker)
* Fixed field lengths reported by SQLDescribeCol() when using functions
such as COMPRESS() in SELECT queries (Bug #20208)
* Fixed 64-bit issues related to SQLINTEGER columns defined as int,
but later cast to long.
* TIME fields were incorrectly converted into date/time values. (Bug #258=
46,
Bug #24867, and Bug #25432)
* Fixed #Deleted issue in Microsoft Access by changing the default behavi=
or
of MyODBC driver regarding SQL_AUTO_IS_NULL variable. Added new option =
to
the GUI and driver
* Fixed memory leak in SQLSpecialColumns()
* Corrected return size of SQLGetStmtAttr() when getting desc handles
* Fixed SQLGetInfo() of SQL_TXN_CAPABLE to return SQL_TC_DDL_COMMIT
* For SQL_C_TIME, handle conversion from the different time-related MySQL
types, instead of always assuming it is just a TIME. (DATETIME, TIMESTA=
MP,
and DATE were all handled incorrectly.)
* Fix crash when default database is not set
* Fix handling of lost connections (Bug #14639)
* File DSNs could not be saved. (Bug #12019)
* Nullability of auto_increment fields is incorrect. (Bug #10130)
* Connector/ODBC may insert the wrong parameter values when using prepared
statements under 64-bit Linux. (Bug #22446)
* The SQLDriverConnect() ODBC method did not work with recent Connector/O=
DBC
releases. (Bug #12393)
* Some properties returned by SQLGetInfo() were set using the wrong data
type, resulting in possible memory overruns. (Bug #20995)
* Ending a transaction using SQLEndTran() on a environment handle was
not supported. (Bug #21588)

Enjoy!

----=20=

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: MySQL Connector/ODBC 3.51.14 is available!

On Wed, Mar 14, 2007 at 11:24:50AM +0000, f.n.cristovao@clix.pt wrote:
> In the DSN configuration dialog, Advanced page, we can see the
> option to enable auto reconnet and its tooltip mentions "it is strongly
> not recommended to set this flag for transactional operations!".
>
> Can you shed some light on this subject?
> Are there any articles describing case scenarios for transction disaster?

I'm not aware of any examples, but it is fairly simple -- if you have
'auto-reconnect' enabled, and are using transactions, and your
connection does an auto-reconnect in the middle of a transaction, you
will be operating in a state where part of your transaction has actually
been rolled back, and you will be doing part of your work in either a
new transaction, or with autocommit suddenly enabled.

So don't use it, and add proper error handling to your application to
deal with being unexpectedly disconnected.

Jim Winstead
MySQL Inc.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org