Querying Index Server via ADO

[giuseppissimo]

Hi Folks!

Since Index Server is an OLE DB provider, I thought: "Hey Gius! Why don't you use ADO to submit SQL queries to Index Server?"

My script is...

$dbc = new COM("ADODB.Connection") or die("Cannot start ADO");
$dbc->Provider = "msidxs";
$dbc->Open("Pippo_Baudo"); # this is my catalog
........
// creation of $sql that will hold the SQL query
....
$rs = $dbc->Execute("$sql"); # submit the query

while (!$rs->EOF) {
?>
<table>
<!-- lets rock and roll with the results-->
<?=$rs->Fields["field_n"]->value?>
</table>
<?
$rs->MoveNext();
}

But it doesn't work... $rs->Fields["field_n"]->value is empty. When I run this script I get ...a lot of HTML that contains nothing.
I have very little experience with Index Server using the triad ADO->COM->PHP, but I don't want to performe this task using....ASP.
Is it right the way I specified the catalog?
Help a poor developer who is in fond of PHP...

Best Regards.

Giuseppe.

[Cayn]

sorry for use this old thread but same problem 🙂

we tested the code from giuseppissimo but same problem so we start to change code to some different:

$objQuery = new COM("ixsso.Query"); 
$querystring = $QUERY_STRING; 
$objQuery->SetQueryFromURL("$querystring"); 
$objQuery->columns = ("filename,HitCount,vpath,DocTitle,characterization"); 
$rsQuery = $objQuery->CreateRecordset("nonsequential") or die("Cannot create set"); 

error message is now
warning: invoke() failed: ........ line blah .....
Cannot create set

any ideas how to get problem solved ?