FreeTDS Development Group

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

Hello guys.. 

  I've been using freetds on my web to connect from ms sql 7.0 with php-4.0.1 
since 3 months ago and it has done great jobs.. 
  But I have a questions that keep bugging me all the time.. can freetds 
handle ms sql 7.0 stored procedures ?? My database stored on MS sql 7.0 all 
with stored procedures which select data from view procedure.. can freetds 
execute a stored procedure ?? and how fast it can run ??

cheers,
Sam


Send your favorite photo with any online greeting!
http://www.whowhere.lycos.com/redirects/americangreetings.rdct

From cameron AT stl.dec.com Thu Aug 10 00:37:30 2000
Return-Path: <cameron AT stl.dec.com>
Received: from zmamail05.zma.compaq.com ([161.114.64.105]) by 
franklin.oit.unc.edu with SMTP (Lyris Server version 3.0); Thu, 10 Aug 2000 
00:37:16 -0400
Received: by zmamail05.zma.compaq.com (Postfix, from userid 12345)
        id 51F285A72; Thu, 10 Aug 2000 00:37:37 -0400 (EDT)
Received: from rmstar.stl.dec.com (rmstar.stl.dec.com [16.153.32.42])
        by zmamail05.zma.compaq.com (Postfix) with ESMTP id 26D815AB2
        for <freetds AT franklin.oit.unc.edu>; Thu, 10 Aug 2000 00:37:35 -0400 
(EDT)
Received: from stl.dec.com (tunnel-153-1-254.sno.dec.com [16.153.1.254])
        by rmstar.stl.dec.com (8.8.8/8.8.6) with ESMTP id OAA01289;
        Thu, 10 Aug 2000 14:37:27 +1000 (EST)
Sender: cameron AT stl.dec.com
Message-ID: <39923183.42F017C3 AT stl.dec.com>
Date: Thu, 10 Aug 2000 14:37:23 +1000
From: James Cameron <cameron AT stl.dec.com>
Reply-To: james.cameron AT compaq.com
Organization: Netrek Vanilla Server Maintainer
X-Mailer: Mozilla 4.7 [en] (X11; I; OSF1 V4.0 alpha)
X-Accept-Language: en
MIME-Version: 1.0
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: ms sql 7.0 stored procedures
References: 
<LYR98561-72050-2000.08.10-00.28.46--james.cameron#compaq.com AT franklin.oit.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Sam Sam wrote:
> can freetds handle ms sql 7.0 stored procedures ??

Works for me.  I just mention the stored procedure name in a query.
I'm using PHP 3.0.15 though.

> and how fast it can run ??

I haven't measured that.

-- 
James Cameron                                      (cameron AT stl.dec.com)

http://www.linux.org/ http://www.linux.org.au/ http://www.freshmeat.net/