I am having problem with PHP executing SQL Stored Procs

focusbizla

Hello,

I am new to PHP

I have a t-sql based stored procedure which I want to execute via PHP, I have tried all odbc_prepare, odbc_execute and odbc_exec but somehow I have not been able to execute the SP.

The SP is perfectly fine as it executes properly from SQL API.

Is there a PHP setting that I need to turn on / enable for this?

Thanks in advance for your help

Atli

Hi.

I thought it was as simple as:

Expand|Select|Wrap|Line Numbers

 
$dbLink = odbc_connect($host, $user, $passwd);

$result = odbc_exec($dbLink,  "exec MyProcedure");

Have you checked if there are functions native to your database type?
Which type of database are you using, by the way?

I am having problem with PHP executing SQL Stored Procs

re: I am having problem with PHP executing SQL Stored Procs

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about