Postgresql datapack not working

remus · Post by **remus** » Sun Apr 12, 2009 1:15 am

Hi
Im using the PostgresSQL datapack (Npgsql) and the latest DLLs from 2008.2 release, I am trying to build the project.
I get the following error: The type or namespace name 'StiSqlDatabaseEditForm' could not be found.

If I substitute the older DLLs from the 2007.1 release it works with one minor change inStiPostgresSQLSource.cs: line 109 of regarding parameter.
ParameterValue however this DLL does not work properly in the Designer or our project, because I cannot create a postgres Connection.

We notice that the 'StiSqlDatabaseEditForm' is not present in the Stimulsoft.Report.Dictonary.Design namespace for the 2008.2 release.
BTW we are using Npgsql version 2.0.4.

Thanks
Philip

Post by **Andrew** » Tue Apr 14, 2009 10:02 am

Hello, Philip.

We'll check it.

Thank you.

remus · Post by **remus** » Fri Apr 17, 2009 4:03 pm

Hi Andrew
We are about to upgrade to the 2008.2 Stimulsoft release.
We are in a desperate situation, to have support for Postgresql for it though.

Could you please help us with this. We have a rather large app and not having the stimusoft postgresql support is a
show stopper for us.

Thanks
Philip

Brendan · Post by **Brendan** » Fri Apr 17, 2009 4:24 pm

Hi Philip,

I think the StiSqlDatabaseEditForm is still at the same namespace but was split into a separate assembly file for 2008.2 and newer versions of Stimulsoft Reports.
This class is present in the Stimulsoft.Report.Design.dll

Maybe try adding a reference to this dll in the PostgresSQL library pack and rebuild it.

remus · Post by **remus** » Sun Apr 19, 2009 7:56 am

Hi Andrew,
Thanks for you help on this - I seem to have some success with your suggestion. Basically the DLL builds now correctly.

My problem now is that once I put all the new DLLs in to the Designer Bin folder as instructed, the Win Report Designer still does not give me the option to create a database with the Postgres connection. When I select New Database, I only have SqlConnection, OleDB Connection, XML data and Odbc connection (same as before).

When I run the Services Configurator, I am able to add the services from the Simulsoft.PostgresSQL.Dll and the new connection option StiPostgresSQLDatabase appears under connections.

SO how do I get the new services to into the Win Designer so I can select a PostgresSQL Connection?

Well with a bit more playing I figured it out. Save the configuration as Stimulsoft.Report.Config in the same folder as the Designer.exe!
Am I right?

Thanks again for a terrific product.

Post by **Jan** » Wed Apr 22, 2009 10:00 am

Hello Philip,

remus wrote: Well with a bit more playing I figured it out. Save the configuration as Stimulsoft.Report.Config in the same folder as the Designer.exe!
Am I right?

Yes this is correct way.

Thank you.