FreeTDS Development Group

["Sam Sam" <s4m AT lycos.com>]

Hello, =))
I wrote a stored procedure which return some value on ms sql server 7.0 my 
stored procedure is like this:
CREATE PROCEDURE sam (@nilai char(1))
if @nilai='A'
  begin
  return 1
  end
else
  begin
  return 0
  end
then i ran a query and fetch_array from php 4.0.1, it didn't return 
anything.. but if i change the return with select statement, it went 
alright.. any explanation on this ??

thanks,
sam




Get your FREE Email and Voicemail at Lycos Communications at
http://comm.lycos.com

From Bernard.ROYET AT sncf.fr Wed Sep 13 04:18:23 2000
Return-Path: <Bernard.ROYET AT sncf.fr>
Return-Path: <Bernard.ROYET AT sncf.fr>
Received: from jasmin.sncf.fr ([171.16.0.7]) by franklin.oit.unc.edu with 
SMTP (Lyris Server version 3.0); Wed, 13 Sep 2000 04:18:14 -0400
Message-ID: <5DDFCC127CEED211A27200105A9CAB7B26AF38@S64P10BM756>
From: "ROYET Bernard (DSIT-EX)" <Bernard.ROYET AT sncf.fr>
To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
Subject: Re: "Connection refused" with MS-SQL 2000
Date: Wed, 13 Sep 2000 09:19:39 +0200
MIME-Version: 1.0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Organization: S.N.C.F. French Railways


Thank you Brian.

MS-SQLserver 2000 uses a different port to communicate : 1067.
I don't know if it is because there is also MS-SQLServer 7 on the PC or =
if
it is a new choice from Microsoft.

Regards.


> Bernard Royet
> Ingres/OpenIngres DBA
> Masterline (Ingres and all CA products consulting)
> Working for a long time in SNCF (French Railways)
> bernard.royet AT sncf.fr
>=20
>=20
> ----------
> De :  Brian Bruns[SMTP:camber AT ais.org]
> R=E9pondre =E0 :      TDS Development Group
> Date :        mercredi 13 septembre 2000 05:41
> A :   TDS Development Group
> Objet :       [freetds] Re: "Connection refused" with MS-SQL 2000
>=20
>=20
> Make sure the dataserver is supporting server logins instead of =
"domain
> logins".  Another test is to see if you can telnet to port 1433 of =
the box
> running SQL Server.  If you get connection refused, make sure that =
the
> port is indeed set for 1433.
>=20
> On Tue, 12 Sep 2000, ROYET Bernard (DSIT-EX) wrote:
>=20
> > Has anyone try to connect MS-SQLServer 2000 with
> DBI+DBD-Sybase-0.23+FreeTDS
> > 0.50 ?
> > All works fine with MS-SQLServer 6.5 / 7.0, but I have a =
"connection
> > refused" error with SQLServer 2000.
> >=20
> > TIA.
> >=20
>=20
>=20
> ---
> You are currently subscribed to freetds as: bernard.royet AT sncf.fr
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>=20