IDS Forum

RE: Unable update through WinSql

Posted By: Larry Beckley
Date: Monday, 22 March 2004, at 12:03 p.m.

In Response To: Re: Unable update through WinSql (Jean Sagi)

Jean,

I apologize if I am pointing out the obvious, but have you looked at the
settings laid down in your ODBC data source?

Larry

-----Original Message-----
From: Jean Sagi [mailto:jeansagi@myrealbox.com]
Sent: Saturday, March 20, 2004 6:24 AM
To: ids@iiug.org
Subject: Re: Unable update through WinSql [2699]


It might be permissions on the table you are trying ti update...

Although the fact that you can do the update with other client is extrange.

Try to issue the update inside dbaccess with the user which have had
problems if there is no errors i the update then permmission are ok and
certainly there is something weird with you winsql.

BTW: I've used winsql since version 3 and I never had any of the problems
you mention.


Chucho!

-----Original Message-----
From: "KchittiBhooma,NarsaReddy" <kchittin@ks2.stph.net>
To: <informix-list@iiug.org>
Date: Fri, 19 Mar 2004 17:41:08 +0530
Subject: Unable update through WinSql

Hello e 1

I having a small problem iwth database,

I am using winsql for clients to access the informix database,

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)
but when try to upadate the same query through SQL Editor 2.0 it was
updating

can any one tell where is the problem.

Thanks,

Kbnreddy




Jean Sagi
jeansagi@myrealbox.com
jeansagi@netscape.net

Messages In This Thread

• Re: Unable update through WinSql
  Jean Sagi -- Saturday, 20 March 2004, at 9:24 a.m.
  • RE: Unable update through WinSql
    Larry Beckley -- Monday, 22 March 2004, at 12:03 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.