Page 1 of 1

Problems connecting to MySQL database

Posted: Wed Jun 15, 2011 5:11 pm
by pier
I'm using Pack trial version 2011.1 from Chrome 12 with flash player 10.3.181.22 on mac os 10.6

I wrote the connection data into database_mysql.php and I hoped the connection would appear in the designer.

I tried creating a new data source (assuming the database_mysql.php would handle the connection), and wrote the select, but it does nothing and a small error icon appear on the data source icon from the data sources list.

So I create a new MySQL connection from inside the designer using this format, and test the connection but it can't connect.

Server=***;Database=***;Uid=***;Pwd=***;

I have triple checked with the system admin the connection string is ok. Other PHP files connect perfectly to the DB with the same data.

I also tried setting False, and then create a data source.... but the same.

¿Why is not working?
¿What is the difference between the php connection and the connection on the flash designer?

Problems connecting to MySQL database

Posted: Wed Jun 15, 2011 5:44 pm
by pier
I tried the trial on another server and it connected, so I assume the problem is on some server configuration or user permissions.

The problem now is that when I write the select, and press "retrieve columns" there is a loading bar, but I never get any columns.

I simply do:

select * from table_name

¿Any ideas?

Problems connecting to MySQL database

Posted: Fri Jun 17, 2011 6:23 am
by Vladimir
Hello,

Please try to upgrade to the latest prerelease build and test it:

http://stimulsoft.com/ReportsFxPHPDownloads.aspx

Thank you.