Calling stored procedure from PHP using PDO to MSSQL Server using INPUT Paramters

Question

This does not work: ``` $dbh = new PDO("dblib:host=xxxx;dbname=xxx", "xxxxx", "xxxxx"); $sth = $dbh->prepare("{exec wcweb_UserInfo(?)}"); $sth->bindParam(1, $name); $sth->execute(); while($result = $sth->fetch(PDO::FETCH_ASSOC)) { var_dump($result); } ``` This also does not work: ``` $dbh = new PDO("dblib:host=xxxxx;dbname=xxxx", "xxxxx", "xxxx"); $sth = $dbh->prepare("{call wcweb_UserInfo(?)}"); $sth->bindParam(1, $name); $sth->execute(); while($result = $sth->fetch(PDO::FETCH_ASSOC)) { var_dump($result); } ``` This DOES work: ``` $dbh = new PDO("dblib:host=xxxxx;dbname=xxxx", "xxxxx", "xxxx"); $sth = $dbh->prepare("exec wcweb_UserInfo @userid=?"); $sth->bindParam(1, $name); $sth->execute(); while($result = $sth->fetch(PDO::FETCH_ASSOC)) { var_dump($result); } ``` I tried the above using 2 that did not work with and without the curly brackets, etc. I know some would say, well just do it the way it works? .. The problem is I am porting an exising application from an IIS Server using t…

Accepted Answer

For some reason this works:

```
  $sth = $dbh->prepare("exec wcweb_UserInfo ?");
  $sth->bindParam(1, $name);
  $sth->execute();

while($result = $sth->fetch(PDO::FETCH_ASSOC)) {
    var_dump($result);
  }
```

I might be able to live with this. Anyone know why the other methods do not work? Is it a difference in the libraries?

Calling stored procedure from PHP using PDO to MSSQL Server using INPUT Paramters

Solution

Problem