RE: reconnect failing in 3.51.12

"John Calcote" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <[email protected]>
Just wanted everyone to know the resolution to this problem. There's an option that can be specified in the (unixODBC) odbc.ini file to enable an option called "auto-reconnect". This option supposedly allows transparent reconnection with a few caveats. 
 
   (/etc/unixODBC/odbc.ini)
   ...
   options = 4194304
   ...
 
The value 4194304 is decimal for the hex value 0x400000, which makes a little more sense - it's a bit flag that indicates an option to the myodbc driver.
 
Using this option, my ODBC client app no longer crashes (yet). To me this is quirky behavior anyway because this option should not be related to the way I was reconnecting anyway. In reality, it's a work-around - allow the underlying driver to reconnect rather than doing it in the app.
 
I'll let you all know if this status changes.
 
Thanks for the suggestions,
John

 
 
-----
John Calcote ([email protected])
Sr. Software Engineeer
Novell, Inc.


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]
John Calcote.vcf (text/plain, 395 B)
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:John Calcote
TEL;WORK:1-801-861-7517
ORG:;Unified Identity System Eng TE
TEL;PREF;FAX:801/861-2292
EMAIL;WORK;PREF;NGW:[email protected]
N:Calcote;John;;Sr. Software Engineer
TITLE:Sr. Software Engineer
ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:John Calcote=0A=
PRV-H-511=0A=
Provo
END:VCARD
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.