Re: ODBC Informix Problem
--0__=09BBE508DFF999908f9e8a93df938690918c09BBE508DFF99990 Content-type: multipart/alternative; Boundary="1__=09BBE508DFF999908f9e8a93df938690918c09BBE508DFF99990" --1__=09BBE508DFF999908f9e8a93df938690918c09BBE508DFF99990 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable The Informix 3.10 ODBC driver is a very old now. Have you tried moving to the latest 3.82 ODBC driver available with CSDK 2.81.TC= 3? What value are you setting SQL_ATTR_TXN_ISOLATION to? The old ODBC driver probably didn't have support for all the isolation settings. Regards, Kanchana Padmanabhan Software Engineer Information Management Division IBM Software Group 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 = robin.cawsey@btin = ternet.com (Robin = Cawsey) = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect ODBC Informix Problem = 02/01/2005 11:09 = AM = = = Please respond to = robin.cawsey = = = Hi, I have a stand allown xp workstation configured with the informix 3.10 ODBC drivers and I have been unable to run the following command in a visual c++ program: SQLSetConnectAttr I'm trying to set the read mode to SQL_ATTR_TXN_ISOLATION, however when the command runs I get an error telling me that the command is not supported by the drivers, however here comes the twist, I can run the same program on a win2K machine using the same drivers and all is well. Can anyone suggest a reason why or a work around? Thanks Rob = --1__=09BBE508DFF999908f9e8a93df938690918c09BBE508DFF99990 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>The Informix 3.10 ODBC driver is a very old now. Have you <br> tried moving to the latest 3.82 ODBC driver available with CSDK 2.81.TC= 3?<br> <br> What value are you setting SQL_ATTR_TXN_ISOLATION to?<br> The old ODBC driver probably didn't have support for all the<br> isolation settings.<br> <br> Regards,<br> Kanchana Padmanabhan<br> <br> Software Engineer<br> Information Management Division<br> IBM Software Group<br> 11200 Lakeview, Lenexa, KS 66219<br> Tel: 913 599 8674 t/l : 337 8674 Fax: 913 599 7260 <br> <br> <img src=3D"cid:10__=3D09BBE508DFF999908f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for robin.cawsey@btinte= rnet.com (Robin Cawsey)">robin.cawsey@btinternet.com (Robin Cawsey)<br>= <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE50= 8DFF999908f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">robin.cawsey@btinternet.com (Robin Cawsey)</fon= t></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">02/01/2005 11:09 AM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> robin.cawsey</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE508DFF999908f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE508DFF999908f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE508DFF999908f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE508DFF999908f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE508DFF999908f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D09BBE508DFF999908f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ODBC Informix Problem</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE508DFF9= 99908f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBE508DFF999908f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Hi,<br> <br> I have a stand allown xp workstation configured with the informix 3.10<= br> ODBC drivers and I have been unable to run the following comm