calling ODBC stored procedure with PHP

Martin

Lifer
Jan 15, 2000
29,178
1
81
title says it all. I can't find anything on google and I am getting frustrated.

I am porting some code from ASP to PHP which calls a stored procedure. In ASP, they make a commad object, put in a SQL statement, add a parameter string, then execute.

I don't know how to do this in PHP. I tried the following

$q = "<sql from asp page>";
$res = odbc_prepare ($QuincyCon, $q);
$exc = odbc_execute($res, array("<parameter value from ASP page"));

but that doesn't work.