Can't connect to postgre

m65jacket · Post by **m65jacket** » Wed Feb 01, 2012 3:24 am

Hi,
I'm trying to connect to postgresql from .fx designer and all I get is connection error (I'm using polish language but error is still in english) in browser designer, and ' this feature is not supported [ApiProvider]' in air designer. Connection string I'm trying to use is something like Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;Password=myPassword;. I don't have any prolems to connect to mssql and mysql.
Please help!

Thank You!

Post by **Vladimir** » Fri Feb 03, 2012 3:45 am

Hello,

The AIR report designer can connect only to XML and MySQL databases, because it uses embedded data adapters. The rest of the database kept for compatibility with the web based designer.

Please let us know what is the connection error displayed in the web based designer while testing the connection.

Thank you.

m65jacket · Post by **m65jacket** » Fri Feb 03, 2012 6:09 am

The message I get is: "Connection error". I can connect to db from other apps so host, db, user id, port and password are correct. I have no idea what I do wrong.
Also i have problem with polish letters (like śćźżął) in ms sql db. I get some garbage in reports. With mysql everything works perfect.

Post by **Vladimir** » Mon Feb 06, 2012 4:33 am

Hello,

Please tell us the version Reports.Fx for PHP which you are using. Also please try to set a EnableDataLogger option to True in the 'config.xml' file, then load the report designer and click the Test connection button. Then in the designer main menu click 'Save Log File' button, save the txt log file and send it to us for analysis.

Thank you.