SetNet32 don't save the variable INFORMIXSERVER in the Registry.

Alejandro

unread,

Nov 28, 2001, 3:00:53 PM11/28/01

to

On Windows Nt, I like to set the Environment Variables of Informix. I
save changes from SetNet32, but, this program don't save the
variables INFORMIXDIR and INFORMIXSERVER in the Registry.

Does anyone know why Setnet32 don't save this variables?

TIA.

Alejandro.

Michael Krzepkowski

unread,

Nov 28, 2001, 4:33:43 PM11/28/01

to

Works for me (2.50 on NT4 SP6)

Michael

Murray Wood

unread,

Nov 28, 2001, 5:50:56 PM11/28/01

to

Always worked for me.
You may need to be administrator or equivalent of your PC.

MW

Richard Spitz

unread,

Nov 29, 2001, 3:55:05 AM11/29/01

to

Which version of Informix-Connect or Informix Client SDK are you using on
your NT box?

Newer versions of these packages have a checkbox "Use my settings" in the
lower left hand corner of the SetNet32 window. You have to check this,
otherwise your settings will not be saved in the HKEY_CURRENT_USER hive
of the registry.

Leonid Belov

unread,

Dec 3, 2001, 8:22:44 AM12/3/01

to

Hello!

Try to check "Use my settings" box on Setnet Environment page.
It is necessary on Windows 2000.

Hope this helps

Leonid

Ken Hu

unread,

Dec 3, 2001, 2:55:34 AM12/3/01

to

Dear All:

I've sucessfully figure out how to use ASP+stored procedure and then get
a recordset.
But if the select statement in my stored procedure returns datas more
than one row, I get an error message said "284: A subquery has returned
not exactly one row."

So I need to know that can a stored procedure return datas more than onw row?
I find something in the documents that talks about "row type data", Does
it has any relation with my question ?

Thansk for any feedback.

Obnoxio The Clown

unread,

Dec 3, 2001, 6:12:48 AM12/3/01

to

No, you probably need to use a cursor.

hype

unread,

Dec 4, 2001, 3:13:53 PM12/4/01

to

I think you wrote a SQL statement inline in the Informix SPL like you
would do in MS-SQL server.You cannot do that in Informix SPL.Fetch
stuff into variables using a cursor and return with resume.

HTH
Hype.

obn...@hotmail.com (Obnoxio The Clown) wrote in message news:<3c0b5e11....@news.cis.dfn.de>...

Obnoxio The Clown

unread,

Dec 4, 2001, 6:39:44 PM12/4/01

to

On 4 Dec 2001 12:13:53 -0800, hypeh...@yahoo.com (hype) wrote:

>I think you wrote a SQL statement inline in the Informix SPL like you
>would do in MS-SQL server.You cannot do that in Informix SPL.Fetch

There is *nothing* I would do in SQL Server.

hype

unread,

Dec 11, 2001, 11:10:30 AM12/11/01

to

obn...@hotmail.com (Obnoxio The Clown) wrote in message news:<3c0d5ea7....@news.cis.dfn.de>...

> On 4 Dec 2001 12:13:53 -0800, hypeh...@yahoo.com (hype) wrote:
>
> >I think you wrote a SQL statement inline in the Informix SPL like you
> >would do in MS-SQL server.You cannot do that in Informix SPL.Fetch
>
> There is *nothing* I would do in SQL Server.

In Informix you cannot do "*nothing*", it is not supported.

Obnoxio The Clown

unread,

Dec 11, 2001, 4:42:29 PM12/11/01

to

On 11 Dec 2001 08:10:30 -0800, hypeh...@yahoo.com (hype) wrote:

>obn...@hotmail.com (Obnoxio The Clown) wrote in message news:<3c0d5ea7....@news.cis.dfn.de>...
>> On 4 Dec 2001 12:13:53 -0800, hypeh...@yahoo.com (hype) wrote:
>>
>> >I think you wrote a SQL statement inline in the Informix SPL like you
>> >would do in MS-SQL server.You cannot do that in Informix SPL.Fetch
>>
>> There is *nothing* I would do in SQL Server.
>
>In Informix you cannot do "*nothing*", it is not supported.

Still struggling to land a gig with the Comedy Store, I see...