Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: Delphi for PHP/Database    [ Add a report in this area ]  
Report #:  78769   Status: Reported
Multiple connections on one form
Project:  HTML5 Builder Build #:  2.1.0.1098
Version:    2.0 Submitted By:   Maciej Tubiszewski
Report Type:  Basic functionality failure Date Reported:  10/19/2009 2:27:00 AM
Severity:    Serious / Highly visible problem Last Updated: 10/23/2009 1:10:57 AM
Platform:    All platforms Internal Tracking #:  
Resolution: None (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
When you try to connect to MySQL and MSSQL on one form of an error connection to MSSQL (MySQL default driver).
Error occurs during the creating forms.
Steps to Reproduce:
None
Workarounds
None
Attachment
mysql_mssql1.zip
Comments

Tomohiro Takahashi at 10/19/2009 6:20:02 PM -
> Error occurs during the creating forms.
What error do you get?
Could you please write Steps and attach sample project to reproduce your issue?

Maciej Tubiszewski at 10/22/2009 4:48:26 AM -
I sent attachments.

mysql_mssql1.php, mysql_mssql.xml.php -
Sample project - shows the error when using any other button (Ajax event).

mysql_mssql1_1.jpg -
View form after loading.

mysql_mssql1_2.jpg -
View form after the first using the "MySQL - click".

mysql_mssql1_3.jpg -
The default controller connect to the database through ADODB.
After changing driver to "mssql" and call off "Database1" button MSSQL - click" working correctly.

mysql_mssql1_4.jpg -
View the error after the second using the "MySQL - click".

mysql_mssql1_5.jpg -
View the error after the second using the "MySQL - click" in log PHP (php_error_log.log ).

Gary Neckers at 10/20/2009 10:25:00 AM -
There was a fix once for using 2 db connections at the same time - it defaulted to the last used one.

Also perhaps it might be the same as http://forums.delphi-php.net/javascript-ajax/3631-ajax-mssql.html#post12701

Maciej Tubiszewski at 10/21/2009 3:42:08 AM -
Does this mean that this is not corrected and using the two routes will not be ever possible?

Gary Neckers at 10/21/2009 5:49:07 PM -
Not sure what it means. I was just giving you a heads up of a couple of things to look at to try and solve your problem.

The fix was committed in Revision 258
Modified Tue Sep 30 09:15:33 2008 UTC (12 months, 3 weeks ago) by ttm
File length: 20609 byte(s)
Diff to previous 253

+Modified MySQL drivers for ADOdb to force a new connection, so it doesn't reuse existing ones

So if that is your problem then you need to check which version of the vcl you are using.

And if it is the default database problem in dbtables.inc.php then you have to mod it yourself as that is an undocumented change.

And if it is neither and you don't want to figure out what is wrong then you could always close and open connections on your own.

Server Response from: ETNACODE01