Hi All

I have been looking for some solution for fetching data using the 
MsSQLLogon() method but for the time being I am able to display data in 
the grid but with no sorting as I have changed the ricoXMLQuery.php file 
totally. But if someone has ever tried to fetch data using MsSQLLogon() 
method and able to do that then please guide me - how to do it? Maybe I 
am on the wrong track.

Looking forward for a reply, atleast from Matt Brown as I have followed 
your examples. And in the ricoXMLResponse.php file you have comments 
mentioned its working fine with SQL Server 2005. So I am sure you have 
some solution for my problem.

Regards

Corepole

In applib.php:

function CreateDbClass() {
  global $oDB;
  $oDB = new dbClass();
  $oDB->Dialect="TSQL";
}

function OpenDB() {
  CreateDbClass();
  return 
$GLOBALS['oDB']->MSSqlLogon("MYSERVER","Northwind","userid","password");
}


MYSERVER should be whatever is displayed in the Server box when you log
into SQL Server Management Studio (may have \SQLEXPRESS or other
instance name suffix depending on how SQL Server was installed). Also,
in order to run the examples you will need to make sure the Northwind
database is installed on the server according to the instructions in
examples/data/readme.txt.

Matt

Hi Matt,

I have the same problems running the ex4panel.php using SQL Server 2005
(I tried the example but the grid doesn't display data).

I made the changes that you indicate in applib.php and follow the
instructions in examples/data/readme.txt but doesn't work.

I'm using Apache / PHP 5.2.6 / Rico 2.0 rc2 / SQL Server 2005.

I made a PHP script test to verify the connection and works fine, using
the same SELECT from the Customer grid of ex4panel.php, retrieves the
rows from customers table.

But trying again ex4panel.php example the grid appears with no data and
displaying the message "Waiting for data..."

TIA,
Pablo