Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: Delphi for PHP/Database/Other    [ Add a report in this area ]  
Report #:  89702   Status: Closed
Reporting MySQL when using MSSQL Server 2005
Project:  HTML5 Builder Build #:   3.0.0.1319
Version:    3.0 Submitted By:   Bjarne Johansson
Report Type:  Basic functionality failure Date Reported:  11/16/2010 5:09:57 AM
Severity:    Critical / Show Stopper Last Updated: 11/21/2010 5:37:31 PM
Platform:    32 Bit Internal Tracking #:  
Resolution: Test Case Error (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
http://www.youtube.com/watch?v=Yf6zIrA1ERQ&feature=player_embedded#!

Is my source for this project.

It's two ComboBoxes. Number one is master the second is detail.

One time the respond is correct. Second time there ar reporting error. To my surprise MySQL is mentioned.

Why is the second database mentioned.


Xajax debug output
Tue Nov 16 2010 13:59:13 GMT+0100: Received: <?xml version="1.0" encoding="utf-8" ?><xjx><cmd n="as" t="ComboBox2_outer" p="innerHTML"><![CDATA[<select name="ComboBox2" id="ComboBox2" size="1" style=" font-family: Tahoma; font-size: 11px; cursor: default;height:16px;width:185px;" tabindex="0" ><option value="0" selected>Spironolakton Nycomed</option><option value="1">Spironolakton Nycomed</option><option value="2">Spironolakton Nycomed</option></select>]]></cmd><cmd n="js"></cmd></xjx>Tue Nov 16 2010 13:59:13 GMT+0100: Calling ajaxProcess uri=/ComboBoxSelection.php?XDEBUG_SESSION_START=d4p&XDEBUG_PROFILE_STOP=1&restore_session=1 (post:xajax=ajaxProcess&xajaxr=1289912353197&xajaxargs[]=Page1&xajaxargs[]=ComboBox1&xajaxargs[]=%3Cxjxobj%3E%3C%2Fxjxobj%3E&xajaxargs[]=ComboBox2BeforeShow&xajaxargs[]=%3Cxjxquery%3E%3Cq%3Eserverevent%3D%26ComboBox1%3D6%26ComboBox2%3D0%3C%2Fq%3E%3C%2Fxjxquery%3E&xajaxargs[]=%3Cxjxobj%3E%3Ce%3E%3Ck%3E0%3C%2Fk%3E%3Cv%3EComboBox2%3C%2Fv%3E%3C%2Fe%3E%3C%2Fxjxobj%3E)Tue Nov 16 2010 13:59:13 GMT+0100: Initializing Request Object..Tue Nov 16 2010 13:59:13 GMT+0100: Starting xajax...
Steps to Reproduce:
<?php
//http://www.youtube.com/watch?v=Yf6zIrA1ERQ&feature=player_embedded#!
//Is the source
require_once("rpcl/rpcl.inc.php");
//Includes
use_unit("forms.inc.php");
use_unit("extctrls.inc.php");
use_unit("stdctrls.inc.php");
use_unit("dbtables.inc.php");
use_unit("db.inc.php");

//Class definition
class Page1 extends Page
{
    public $ComboBox2 = null;
    public $Query2 = null;
    public $dbTest_BjarneSQL1 = null;
    public $ComboBox1 = null;
    public $Query1 = null;
    public $Datasource1 = null;
    public $Datasource2 = null;
    function ComboBox1BeforeShow($sender, $params)
    {
    $this->ComboBox1->Clear();
    $this->Query1->first();
    while (!$this->Query1->EOF)
    {
    $this->ComboBox1->AddItem($this->Query1->tillverkare);
    $this->Query1->next();
    }

    }
    function ComboBox2BeforeShow($sender, $params)

    {
     $this->ComboBox2->Clear();
    $this->Query2->close();
    $State=$this->ComboBox1->Items[$this->ComboBox1->ItemIndex];
    $this->Query2->Params = array($State);
    $this->Query2->open();

     while (!$this->Query2->EOF)
     {
     $this->ComboBox2->AddItem($this->Query2->handelsnamn);
     $this->Query2->next();

    }

    }
    function ComboBox1JSChange($sender, $params)
    {
      echo
      $this->ComboBox1->ajaxCall('ComboBox2BeforeShow', array(),array('ComboBox2'));


        ?>
        //Add your javascript code here
        reload();

        <?php
    }

    }


//}
global $application;

//
global $Page1;

//Creates the form
$Page1=new Page1($application);

//Read from resource file
$Page1->loadResource(__FILE__);

//Shows the form
$Page1->show();

?>



Error: the XML response that was returned from the server is invalid.
Received:
<br />
<b>Warning</b>:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'BJARNE-DATOR\SQLEXPRESS2005' (11004) in <b>C:\Program Files\Embarcadero\RadPHP\3.0\rpcl\adodb\drivers\adodb
Workarounds
None
Attachment
None
Comments

Tomohiro Takahashi at 11/16/2010 6:15:58 PM -
Could you please attach entire sample project(sample table schema and test data) to reproduce/verify your issue?

Bjarne Johansson at 11/21/2010 3:36:22 AM -
Thank You for asking me.

I'm learning RADPHP. I made something wrong in the beginning.
Now I can connect to MSSQL.

MySQL is the default database in RADPHP.

That's why we got this information It's surprised me a lot.

That information was found.

I can now close this question.

Tomohiro Takahashi at 11/21/2010 5:35:43 PM -
Ok, I closed this report as Sysop.
Thanks.

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.