Problem in Grid loading data from oracle 10g

Suite and Optimus Suite 5
#1

hi guyz, i want to load data to my grid from oracle database 10g
i attached i jpeg file for my screenshot of error
here is my main page

[code]

<link rel="stylesheet" href="dhtmlxGrid/common/dhtmlx.css" type="text/css" charset="utf-8">
<script src="dhtmlxGrid/common/dhtmlx.js" type="text/javascript" charset="utf-8"></script>
<script src="dhtmlxGrid/dhtmlxConnector/codebase/connector.js" type="text/javascript" charset="utf-8"></script>
<link rel="stylesheet" href="dhtmlxGrid/common/dhtmlx.css" type="text/css" charset="utf-8">


[/code]

and this is my connector

[code]<?php
require_once(“…/config.php”);
$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db($mysql_db);

require("../dhtmlxConnector/codebase/grid_connector.php");
$grid = new GridConnector($res);
$grid->enable_log("temp.log",true);
$grid->dynamic_loading(100);
$grid->render_table("grid50000","item_id","item_nm,item_cd");

?>[/code]

and this is my config

[code]<?php
$mysql_server=“mldb1003:1521”;
$mysql_user = “ERXXA”;
$mysql_pass = “ERXXA”;
$mysql_db = “EXPROJ@TPD”;
$excel_file = “…/common/excel_sample.xls”;

//necessary for PostgreSQL related samples only 
$postrgre_connection = "host=MLDB1003 port=1521 dbname=EXPROJ@TPD user=erxxa password=erxxa";
//necessary for Oracle related samples only 
$oci_connection = "some here";

?>[/code]
please help me i badly need this to work
thanks in advance

error1.JPG575×633 13 KB

#2

BUMP

#3

connector init for oracle will look similar to next

	require("../../codebase/grid_connector.php");
	require("../../codebase/db_oracle.php"); //extra include

        $res = oci_connect("ERXXA","ERXXA","mldb1003:1521/EXPROJ@TPD");	
	$grid = new GridConnector($res,"Oracle"); //different second param
        //all fields in upper case
	$grid->render_table("EMPLOYEES","EMPLOYEE_ID","FIRST_NAME,LAST_NAME");

Be sure that you have oci extension enabled in php.ini
Also, I’m not quite sure about valid connection string in your case, if the above one doesn’t work - check php.net/oci_connect for more details

#4

Dear user,

Try to put all the column names in uppercase, like that:

    //Initializes connector
	GridConnector c = new GridConnector(connection, DBType.Oracle);
            //configures the used table and fields
	c.dynamic_loading(200);
	c.render_table("SS_REMOTE_MACHINES", "ID", "HOST,NAME,DESCRIPTION,METHOD,REMOTE_ID,LAST_UPDATED");