Problem with OpenLinks drivers (and InterSolv, too) using Java
This is a multi-part message in MIME format. ------=_NextPart_000_0040_01BD8AFE.1BE412A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've downloaded the Lite Single-Tier ODBC driver from OpenLinks to = evaluate. It was very easy to set up however I've run into some problems. I'm using them with = a Java application. Our application runs fine with the Intersolv drivers = provided by Informix. However, when I use the OpenLinks, I get the error message " -1802 = Connection name in use. A connection with same connection has already been made. Each = connection must have a unique connection name. Rename the connection and try = again." I don't know where the connections are named, and I thought I was using = the same=20 connection. Is there some restriction on the Lite version to where = they're unable to work? Also, I've come across one problem in the Intersolv driver using = Informix. When I insert or update a decimal column using PreparedStatement.setNull() = method, I get the error message "[INTERSOLV][ODBC Informix Driver] Character, = decimal, and binary parameters cannot have a precision of zero. Error in parameter = 4." So, basically I can't insert or update null decimal columns using this = driver (unless it is a JDBC bug, which I was trying to determine using the OPenLinks driver). Any help on either of these problems is greatly appreciated! Candy -- Candy McCall ONLINE Computing, Inc. (candym@olcinc.com) PS. I'm using JDBC-ODBC bridge using JDK1.1.6 ------=_NextPart_000_0040_01BD8AFE.1BE412A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#d8d0c8> <DIV><FONT color=3D#000000 size=3D2>I've downloaded the Lite Single-Tier = ODBC driver=20 from OpenLinks to evaluate. It was very</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>easy to set up however I've run into = some=20 problems. I'm using them with a Java</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>application. Our application = runs fine=20 with the Intersolv drivers provided by Informix.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>However, when I use the OpenLinks, I = get the=20 error message " -1802 Connection name</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>in use. A connection with same = connection has=20 already been made. Each connection</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>must have a unique connection = name. Rename=20 the connection and try again."</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>I don't know where the connections = are named,=20 and I thought I was using the same </FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>connection. Is there some = restriction on=20 the Lite version to where they're unable to work?</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2> Also, I've come = across one=20 problem in the Intersolv driver using Informix. When</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>I insert or update a decimal column = using=20 PreparedStatement.setNull() method,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>I get the error message = "[INTERSOLV][ODBC=20 Informix Driver] Character, decimal, and</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>binary parameters cannot have a = precision of=20 zero. Error in parameter 4." So,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>basically I can't insert or update = null decimal=20 columns using this driver (unless it is</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>a JDBC bug, which I was trying to = determine=20 using the OPenLinks driver).</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2> Any help on = either of these=20 problems is greatly appreciated!</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>Candy</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>--<BR>Candy McCall<BR>ONLINE = Computing,=20 Inc.<BR>(<A = href=3D"mailto:candym@olcinc.com">candym@olcinc.com</A>)</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT size=3D2>PS. I'm using JDBC-ODBC bridge using=20 JDK1.1.6</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0040_01BD8AFE.1BE412A0--