Stored Procedure not running

[alisoylu]

I have a weird problem.
I constuct a query to call a stored procedure with some parameters, and the stored procedure is for inserting data into the db (into a couple of tables)

When I send this to the SQL Server (MSSQL), using ODBC or the mssql_ calls, the record does not always get inserted (works 20% of the time)

However if I copy paste the exact query into osql it works.

I have tried calling exec and running osql from php, that works too. But I can't get it to work with ODBC or mssql_ functions.

Any ideas?

ALi