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. But sometimes it works and
sometimes not, it depends on what is in the stored
procedure. And I am sure that every stored procedure I
put into sybase_query() can be run on SQL Server
Query Analyzer perfectly. 
e.g. 
SP1:  (works)  
CREATE PROCEDURE SP1 AS
insert into mytable values(...)
select * from mytable

SP2:  (doesn't work)
CREATE PROCEDURE SP2 AS
select * from mytable
select * from mytable

SP3:  (doesn't work)
CREATE PROCEDURE SP3 AS
insert into mytable values(...)
insert into mytable values(...)

It looks that the sybase_query() is not stable. I am
not the person doing freetds setup on this Unix
machine. Do you think this is a freetds related
problem?

--- olinux o [EMAIL PROTECTED] wrote:
 test
 
 --- jong jong [EMAIL PROTECTED] wrote:
  Hi,
  
  I am working on Unix(Solaris 2.8) with Apache 1.3
  and 
  php4. I need to connect MS-SQL Server without
 ODBC.
  Someone told me that sybase functions can work
 with
  MS-SQL Server. So I called sybase_xxx()
  instead of mssql_xxx(). I was surprised that most
 of
  them really work! But the problem is that
  sybase_query() seems only work for select ...
  statement. When I tried to pass
  insert...,update... or delete..., this
  function
  returned false, but the database was actually
  updated. And the following sybase_query() would
  always
  return false even it is for select
  
  Here is an example:
  $conn=sybase_connect(MS-SQL
  Server,login,password);  //successful
  sybase_select_db(db,$conn);  //return true
  $result=@sybase_query(select ...,$conn); 
 //Great!
  That's what I want.
  sybase_free_result($result);  //no problem so far
  $result=@sybase_query(insert ...,$conn); 
 //return
  false, but I did insert a new record into SQL
  Server.
  sybase_free_result($result);  //successful
  $result=@sybase_query(select...,$conn); //return
  false, can't work with select... any more.
  ...
  
  Anybody had same experience before? I will
  appriecate
  any information from you.
  
  Wen
  
  
  __
  Do You Yahoo!?
  Get personalized email addresses from Yahoo! Mail
  http://personal.mail.yahoo.com/
  
  -- 
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, e-mail:
  [EMAIL PROTECTED]
  For additional commands, e-mail:
  [EMAIL PROTECTED]
  To contact the list administrators, e-mail:
  [EMAIL PROTECTED]
  
 
 
 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail
 http://personal.mail.yahoo.com/


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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)
 CREATE PROCEDURE SP3 AS
 insert into mytable values(...)
 insert into mytable values(...)

Two results.

The sybase extension is not written to handle multiple results in a single query. I 
have writteh the code for this in the MSSQL extension, but so far this extension is 
only available on Windows.

- Frank




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[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 mssql_xxx(). I was surprised that most of
them really work! But the problem is that
sybase_query() seems only work for select ...
statement. When I tried to pass
insert...,update... or delete..., this function
returned false, but the database was actually
updated. And the following sybase_query() would always
return false even it is for select

Here is an example:
$conn=mssql_connect(MS-SQL
Server,login,password);  //successful
sybase_select_db(db,$conn);  //return true
$result=@sybase_query(select ...,$conn);  //Great!
That's what I want.
sybase_free_result($result);  //no problem so far
$result=@sybase_query(insert ...,$conn);  //return
false, but I did insert a new record into SQL Server.
sybase_free_result($result);  //successful
$result=@sybase_query(select...,$conn); //return
false, can't work with select... any more.
...

Anybody had same experience before? I will appriecate
any information from you.

Wen


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]