Informix, 7.31.TD4 and Windows 2000 SP3: -951 error

Matthieu AMIRAUL
#1 / 4

7.31.TD4 and Windows 2000 SP3: -951 error

Hello,

Since the installation of the Windows 2000 SP3, a -951 (bad user/password)
error is encountered for all the clients.
Of course the configuration of the accounts did not change...

Has everybody an idea ?

Thanx a lot

JB Albertus

Fri, 25 Feb 2005 16:21:53 GMT

Joe Bake
#2 / 4

7.31.TD4 and Windows 2000 SP3: -951 error

Is there a way to trace the SQL requests which are being made to the
database.
We have a proprietary application which sends SQL requests to Informix and
I'd like to duplicate, then modify the SQL a bit to create a report which
suits our
needs better.

I believe the application is written in C and that they use a some
development
package called Panther to build the input screens.

Joe Baker
Systems Administrator
Wauwatosa Police Department
414-471-8430 Office
414-788-8284 Cell

Sat, 26 Feb 2005 05:45:03 GMT

Richar
#3 / 4

7.31.TD4 and Windows 2000 SP3: -951 error

Quote:

> Is there a way to trace the SQL requests which are being made to the
> database.
> We have a proprietary application which sends SQL requests to Informix and
> I'd like to duplicate, then modify the SQL a bit to create a report which
> suits our
> needs better.

> I believe the application is written in C and that they use a some
> development
> package called Panther to build the input screens.

You can use onstat -g sql -r for a very primitive solution or you can
buy I-SPY which is probably not ideal for an OLTP production environment
but is very powerful and flexible or you can use SQLIPRINT, which is
arcane and a bit of a resource hog.

http://groups.google.com/groups?q=informix+sqliprint+leffler&hl=en&lr...

Sat, 26 Feb 2005 05:57:51 GMT

Rajib Sarka
#4 / 4

7.31.TD4 and Windows 2000 SP3: -951 error

If you are using 9.30 you can use onstat -g stm <session id> to trace all
the PREPARED SQL statements for the session.

Thanx much,

Rajib Sarkar
Advisory Support Engineer(Wells Fargo Bank)
IBM Software Group -- Data Management
Ph: 602-2172100, Fax: 602-2172100

www.ibm.com/software

"Joe Baker"

watosa.net> cc:
Sent by: Subject: Tracing SQL
owner-informix-lis

09/09/2002 02:45
PM
Please respond to
"Joe Baker"

Is there a way to trace the SQL requests which are being made to the
database.
We have a proprietary application which sends SQL requests to Informix and
I'd like to duplicate, then modify the SQL a bit to create a report which
suits our
needs better.

I believe the application is written in C and that they use a some
development
package called Panther to build the input screens.

Joe Baker
Systems Administrator
Wauwatosa Police Department
414-471-8430 Office
414-788-8284 Cell

Sat, 26 Feb 2005 06:56:57 GMT