Stored procs and transactions using Linux/PHP and Windows/MSSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is anyone using PHP5 on Linux to connect to MS SQL Server 2000 on Windows and execute stored procedures with output parameters within a transaction? If so, how?

I'm trying to do something like this in the PHP application:

begin transaction
execute a stored procedure, receiving an identity back
if certain conditions are met
   execute another stored procedure, getting an identity
if certain other conditions are met
   execute another stored procedure, getting an identity
if any of the above procedures fail
   rollback transaction
else
   commit transaction

I ran into some problems using both PDO and the mssql_* functions (if someone is successful using one of these, I'll likely be asking in a future message for help with the problems I'm encountering).

I'm just asking to see if anyone is successfully doing what I'm trying to do, and if so, what method is being used to accomplish it.

Thanks in advance,
Rick

--
Rick Emery

"When once you have tasted flight, you will forever walk the Earth
 with your eyes turned skyward, for there you have been, and there
 you will always long to return"
                                              -- Leonardo Da Vinci

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux