PDA

View Full Version : [AMFPHP] Return a recordset from Microsoft SQL Server?


Louis Roy
05-12-2008, 08:45 PM
Hey guys,

I'm using this connection string to fetch some results in AMFPHP :

$this->Con = new COM('ADODB.Connection') or die('Cannot start ADO.');
$this->Con->Open("Provider=sqloledb;Data Source=qbc-dev;Initial Catalog=datab;User Id=admin;Password=1234");

It works fine if I return a particular field (ex: $rsSelect->Fields[0]->value) but the service browser just freezes when I try to return a entire recordset (it doesn't return anything, not even some kind of error message).

Any idea what's going on? I am wondering if it could be my sql provider (sqloledb) that may be not supported.

Thanks!