Problems connecting to MySQL database

Stimulsoft Reports.PHP discussion
Post Reply
pier
Posts: 27
Joined: Wed Jun 15, 2011 4:58 pm
Location: Mexico

Problems connecting to MySQL database

Post 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?
pier
Posts: 27
Joined: Wed Jun 15, 2011 4:58 pm
Location: Mexico

Problems connecting to MySQL database

Post 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?
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Problems connecting to MySQL database

Post by Vladimir »

Hello,

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

http://stimulsoft.com/ReportsFxPHPDownloads.aspx

Thank you.
Post Reply