Re: [PHP-DB] sybase function for MS-SQL Server

2001-06-30 Thread jong jong
I am almost crazy now after playing with these codes over 10 hours. I don't expect to call sybase_query() one by one for executing sql batch. It just doesn't work for me like what I said yesterday. Now I try to make a stored procedure for these sql batch. So I can call sybase_query() only once.

Re: [PHP-DB] sybase function for MS-SQL Server

2001-06-30 Thread Frank M. Kromann
Hi, Query Analyzer perfectly. e.g. SP1: (works) CREATE PROCEDURE SP1 AS insert into mytable values(...) select * from mytable Only one result set. SP2: (doesn't work) CREATE PROCEDURE SP2 AS select * from mytable select * from mytable Two result sets SP3: (doesn't work)

[PHP-DB] sybase function for MS-SQL Server

2001-06-29 Thread jong jong
Hi, I am working on Unix(Solaris 2.8) with Apache 1.3 and php4. I need to connect MS-SQL Server without ODBC. I know there is an option that using freetds but I haven't tried it yet. Someone told me that sybase functions can work with MS-SQL Server directly. So I called sybase_xxx() instead of