SQL 2005 Reporting Services help

heafield · Post by **heafield** » Mon 15 Oct 2007 01:33

Hi,
I've been using the postgreSQLDirect.NET fine in asp.net forms. I am trying now to connect to write SQL Reports but having difficultly with trying to connect to the PostGres DB? Do you have any instructiosn or help to do this please as I need to produce reports. Great driver and quick.
thanks you.

Alexey · Post by **Alexey** » Mon 15 Oct 2007 08:28

Please describe the problem in detail.
What version of PostgreSQLDirect are you using?

heafield · Post by **heafield** » Mon 15 Oct 2007 09:22

Hi,
Latest version:
PgSQLDirect .NET 3.20 for .NET 2,
thanks

Alexey · Post by **Alexey** » Mon 15 Oct 2007 09:36

Alexey wrote:Please describe the problem in detail.

heafield · Post by **heafield** » Tue 16 Oct 2007 01:57

Hi, yes thanks fo help.
I'm trying to connect in VS.NET 2005 Reporting services a datasource in the report and I cannot acces the Postgres driver. Also I'm trying a connection string but don't know what it should be?
Hope this makes sense.

Is there a defined way that I should be setting up a datasource in a report?

heafield · Post by **heafield** » Tue 16 Oct 2007 02:07

I'm also trying to use a connection string like;
Provider=PostgreSQL.1;host=125.236.51.105;database=aaa;schema=aaa

Alexey · Post by **Alexey** » Tue 16 Oct 2007 07:08

OK, I'll try to guide you.
When you create a fresh Report Project you see Shared Data Sources group in the Solution Explorer. Right-click it and choose Add New Data Source item. From a Type combobox choose CoreLab.PostgreSql item. If it is absent, then something wrong with the installation. You should check whether appropriate section about PostgreSQLDirect .NET exists in the DbProviderFactories section of your machine.config file. If CoreLab.PostgreSql item is in the list, choose it and fill Connection String memo below. The connection string should look like the following:

Code: Select all

User Id=postgres;Password=postgres;Database=postgres;Schema=public;Host=192.168.0.1;Port=5432;

Then specify your login/password on a Credentials tab and press OK button. You are done. Now you can add reports choosing just created data source from the Shared Data Source combobox.