Configure postgres

esr · Post by **esr** » Sun Jul 18, 2010 12:55 pm

Hello.
Currently developing applications with Delphi for PHP and PostgreSQL. How I have to configure "Stimulsoft Reports.Fx for PHP" for use with postgres?.
When I try to configure the connection Dictionary-> New Connection-> only appears: "XML Data" and "MySQL Connection".

Thank you very much.

ESR.

Vladimir · Post by **Vladimir** » Mon Jul 19, 2010 5:05 am

Hello,

Support for PostgreSQL data sources has already been finished, the new version of Stimulsoft Reports.Fx for PHP will be available tomorrow.

Thank you.

esr · Post by **esr** » Thu Jul 22, 2010 11:45 am

Hello.
Today I downloaded the latest version available for php, and still shows no connection to postgres or through ODBC.
ESR

Edmund Andersson · Post by **Edmund Andersson** » Fri Jul 23, 2010 5:35 am

Beta 2 is the "old" Beta Version, a new version is still not released.

/Edmund Andersson

Post by **Jan** » Fri Jul 23, 2010 2:44 pm

Hello,

New version will be available at 24 July. At this moment we at final stage of testing.

Thank you.

Post by **Andrew** » Tue Jul 27, 2010 12:14 am

Hello,

Sorry for the delay with response. Our new Beta 3 version is published.

Thank you.

esr · Post by **esr** » Tue Jul 27, 2010 12:10 pm

Hello.
I have tried to connect, but I could not. I am using the following parameters:
Server=localhost;Port=5432;Database=DEMO;UserId=postgres;Password=123456;

Could help to correctly configure postgres connection?

Vladimir · Post by **Vladimir** » Wed Jul 28, 2010 3:31 am

Hello,

We checked the connection to PostgreSQL database and found an error on the server side script. We send you a corrected PHP script, please see the attacher archive.

Thank you.

tony.tomov · Post by **tony.tomov** » Sat Jul 31, 2010 4:02 am

Hello Vladimir,

I think that PostgreSQL driver has a lot of bugs.

1. It seems like the PosgreSQL driver uses parseMySqlConnectionString to configure connection.
This is wrong since the default port of PostgreSQL is 5432 and not 3306 (MySQL)
In order to fix I think that a separate parsePgSqlConnectionString function should be created with the following default settings.

Code: Select all

	function parsePgSqlConnectionString($connectionString)
	{
		class connectionInfo {
			var $host;
			var $port = "5432";
			var $database;
			var $userId;
			var $password;
		}
...

2. The function getPostgreSQLDatabaseColumns uses a wrong convertMySqlType function to get the field types.
In order to fix I have created convertPgSqlType which replaces convertMySqlType in getPostgreSQLDatabaseColumns function.
The function look like this (It can be refined)

Code: Select all

	function convertPgSqlType($type)
	{
		switch (strtolower($type))
		{
			case "varchar":
			case "bpchar":
			case "macaddr":
			case "inet":
			case "money":
			case "text":
				return "System.String";

			case "bool":
				return "System.Boolean";

			case "bit":
			case "int8":
			case "int4":
			case "int2":
			case "interval":
				return "System.Int32";

			case "float4":
			case "float8":
			case "numeric":
				return "System.Decimal";

			case "date":
			case "time":
			case "timetz":
			case "timestamp":
			case "timestamptz":
				return "System.DateTime";
			default:
			 	return "System.String";				
		}

		return $type;
	}

Hope this help

Kind Regards
Tony

Vladimir · Post by **Vladimir** » Mon Aug 02, 2010 4:53 am

Hello, Tony

Thank you for you excellent help, we will include these corrections in the next version of Reports.Fx for PHP.

Thanks.