Informix OLE DB Provider

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C02493.19FBB976 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, =20 I am a new member of Informix-list and a new user of Informix = databases. I searched for answers to my question in the Informix-list's archives = but it was not always clear for me. So I repeat the problem concerning Informix OLE DB Provider. =20 I am working with IDS Workgroup Edition 7.31.TC5 for Windows NT and Informix-SDK 2.40.TC1-1 for Windows NT too. I want to update data with DataGrid and ADO from Visual Basic 6.0 SP4. =20 My problem is that with the same ADO's properties the update works fine = with Microsoft OLE DB Provider with ODBC drivers but not with Informix OLE = DB Provider. In the last case I have the following error message: "X42000:-201:Syntax error or access violation". =20 The main ADO's properties for both cases are: - CursorLocation =3D adUseClient - CursorType =3D adOpenDynamic - LockType =3D adLockOptimistic - Mode =3D adModeReadWrite =20 The connection strings are: - using Microsoft OLE DB Provider=3DMSDASQL.1;Password=3Dxxx;Persist Security Info=3DTrue;User ID=3Dxxx;Data Source=3Dstores7_fos14;Initial Catalog=3Dstores7 - using Informix OLE DB Provider=3DIfxoledbc;Password=3Dxxx;Persist Security Info=3DTrue;User ID=3Dxxx;Data Source=3Dstores7@ol_fos14;Extended Properties=3D"" =20 At last I don't know if it is essential but I notice in the "data link properties" window that the access permissions are accessible with = Microsoft OLE DB but not with Informix OLE DB. =20 Does anyone have an idea about this ? =20 Thanks =20 Val=E9rie LE KIM Sema Group Tour Horizon 64, rue du 8 Mai 1945 92000 Nanterre France --------------------------- <mailto:valerie.le-kim@sema.fr> valerie.le-kim@sema.fr ---------------------------------- ------_=_NextPart_001_01C02493.19FBB976 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>Hello,</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>I am a new member of Informix-list and a new user of Informix databases.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>I searched for answers to my question in the Informix-list's archives but it was not always clear for me.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>So I repeat the problem concerning Informix OLE DB Provider.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>I am working with IDS Workgroup Edition 7.31.TC5 for Windows NT and Informix-SDK 2.40.TC1-1 for Windows NT too.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>I want to update data with DataGrid and ADO from Visual Basic 6.0 SP4.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>My problem is that with the same ADO's properties the update works fine with&nbsp;</SPAN></FONT><FONT face=Arial size=2><SPAN class=560462015-21092000>Microsoft OLE DB Provider with ODBC drivers but not with Informix OLE DB Provider. In the last case I have the following error message: "X42000:-201:Syntax error or access violation".</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>The main ADO's properties for both cases are:</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>- CursorLocation = adUseClient</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>- CursorType = adOpenDynamic</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>- LockType = adLockOptimistic</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>- Mode = adModeReadWrite</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>The connection strings are:</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>- using Microsoft OLE DB</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>&nbsp; Provider=MSDASQL.1;Password=xxx;Persist Security Info=True;User ID=xxx;Data Source=stores7_fos14;Initial Catalog=stores7</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>- using Informix OLE DB</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>&nbsp; Provider=Ifxoledbc;Password=xxx;Persist Security Info=True;User ID=xxx;Data Source=stores7@ol_fos14;Extended Properties=""</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>At last I don't know if it is essential but I notice in the "data link properties" window that the access permissions are accessible with Microsoft OLE DB but not with Informix OLE DB.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT><FONT face=Arial size=2><SPAN class=560462015-21092000>Does anyone have an idea about this ?</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=560462015-21092000>Thanks</SPAN></FONT></DIV> <DIV>&nbsp;</DIV> <DIV> <DIV><FONT face=Tahoma size=2>Val'rie LE KIM</FONT></DIV> <DIV><FONT face=Tahoma size=2>Sema Group</FONT></DIV> <DIV><FONT face=Tahoma size=2>Tour Horizon</FONT></DIV> <DIV><FONT face=Tahoma size=2>64, rue du 8 Mai 1945</FONT></DIV> <DIV><FONT face=Tahoma size=2>92000 Nanterre</FONT></DIV> <DIV><FONT face=Tahoma size=2>France</FONT></DIV> <DIV><FONT face=Tahoma size=2>---------------------------</FONT></DIV> <DIV><FONT face=Tahoma size=2><A href="mailto:valerie.le-kim@sema.fr"><EM>valerie.le-kim@sema.fr</EM></A></FONT></DIV> <DIV><FONT face=Arial size=2>----------------------------------</FONT></DIV></DIV></BODY></HTML> ------_=_NextPart_001_01C02493.19FBB976--