Unable update through WinSql
Posted in 2004
This is a multi-part message in MIME format. ------_=_NextPart_001_01C40DAB.42D6C39A Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello e 1 I having a small problem iwth database, I am using winsql for clients to access the informix database,=20 all are user are able to connect and doing DML operations but one user = machine if he is trying to update he is getting the following error Error: No UPDATE permission. (State:4200, Native Code: FFFFFFFF)=20 but when try to upadate the same query through SQL Editor 2.0 it was = updating=20 can any one tell where is the problem. Thanks, Kbnreddy ------_=_NextPart_001_01C40DAB.42D6C39A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 6.0.5762.3"> <TITLE>Unable update through WinSql</TITLE> </HEAD> <BODY> <!-- Converted from text/rtf format --> <P><FONT SIZE=3D2 FACE=3D"Arial">Hello e 1</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">I having a small problem iwth = database,</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">I am using winsql for clients to access = the informix database, </FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">all are user are able to connect and = doing DML operations but one user machine if he is trying to = update he is getting the following error</FONT></P> <P><FONT SIZE=3D2 FACE=3D"Times New Roman">Error: No UPDATE permission. = (State:4200, Native Code: FFFFFFFF)</FONT><FONT FACE=3D"Times New = Roman"> </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">but when try to upadate the same query = through SQL Editor 2.0 it was updating </FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">can any one tell where is the = problem.</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Kbnreddy</FONT> </P> <BR> </BODY> </HTML> ------_=_NextPart_001_01C40DAB.42D6C39A-- sending to informix-list