PostgreSQL Adapter Service

csitol · Post by **csitol** » Wed Apr 23, 2008 2:46 pm

Hello,

I successfully installed the PostgreSQL Database pack. Everything worked perfectly, until I tried to execute the report. Instead of displaying about 20 different values, it displayed 20 of the same value.

I had previously tested this exact same code with the OleDB version of the PostgreSQL provider and it worked perfectly.

Any suggestions? I would very much like to use the adapter you provide instead of the OleDB, if possible.

BTW, this is a SPECTACULAR product. Thank you so much!

Phil Mickelson
CSITOL, LLC

Post by **Vital** » Thu Apr 24, 2008 12:48 am

Hello,

I successfully installed the PostgreSQL Database pack. Everything worked perfectly, until I tried to execute the report. Instead of displaying about 20 different values, it displayed 20 of the same value.

I had previously tested this exact same code with the OleDB version of the PostgreSQL provider and it worked perfectly.

Any suggestions? I would very much like to use the adapter you provide instead of the OleDB, if possible.

We will test this problem. I will inform you about result in this topic.

BTW, this is a SPECTACULAR product. Thank you so much!

Thanks for your words!

Post by **Edward** » Thu Apr 24, 2008 1:37 pm

Please use the following link for downloading of the latest versions of Npgsql.dll and Mono.Security.dll:

http://pgfoundry.org/frs/download.php/1 ... .1-src.zip

Then copy these dlls and Stimulsoft.Report.PostgreSQL.dll to the folder with your project and in this case version 2008.1 or 2008.2 prereleases work as expected, without need of OleDb. Here is my ConnectionString, which I used for testing:

Server=localhost;Port=5432;Protocol=3;SSL=false;Pooling=true;MinPoolSize=1;MaxPoolSize=20;Encoding=UNICODE;Timeout=15;SslMode=Disable;Userid=postgres;Password=test;

If the issue is still present then send a test solution to support[at]stimulsoft.com for analysis.

Thank you.

csitol · Post by **csitol** » Thu Apr 24, 2008 2:26 pm

Edward,

I downloaded the 1.1 version of Npgsql. That appears to have been the problem. I was originally using the latest beta version. It (the latest beta) worked in a different situation but, apparently, not with Stimulsoft. No problem.

Thank you very much for solving this for me. Being able to use the native driver will save me a lot of money and time!

Regards,

Phil Mickelson
CSITOL, LLC

Post by **Edward** » Thu Apr 24, 2008 2:45 pm

Please do let us know about your results.

Thank you.

csitol · Post by **csitol** » Thu Apr 24, 2008 4:15 pm

Edward,

I was able to successfully design a report very similar to the one that is used in the Flash sample (How to create a report in Web with SQL Server). However, I used PostgreSQL and my own database.

The design worked perfectly and I was able to display the data in the preview mode.

I created a simple web form (completely new web site. Nothing except the single page with the StiWebViewer and StiWebReport components). I moved the files Mono.Security.dll (v 2.0.0.0), Npgsql.dll (v 1.0.0.0) and Stimulsoft.Report.PostgreSQL.dll (v 2008.1.200.0) into the Bin subdirectory (as references). These are, btw, the exact same files that are in the Bin subdirectory with the Design.exe program.

When I execute the program I get the following error message: "Database Stimulsoft.Report.Dictionary.StiPostgreSQLDatabase not found"

Thank you in advance for your help!

Phil Mickelson
CSITOL, LLC

csitol · Post by **csitol** » Thu Apr 24, 2008 8:24 pm

Please disregard my previous post. I have found the correct instructions in the download for the PostgreSQL adapter from your web site. It's working perfectly.

Thank you again for a wonderful product. We'll be ordering the full license very soon!

Phil Mickelson
CSITOL, LLC

Post by **Edward** » Wed Apr 30, 2008 10:11 am

Thank you for your words.

Please let us know if any help is required.

Thank you.