SQL 2005 Reporting Services help

SQL 2005 Reporting Services help

Postby 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.
heafield
 
Posts: 5
Joined: Mon 15 Oct 2007 01:31

Postby Alexey » Mon 15 Oct 2007 08:28

Please describe the problem in detail.
What version of PostgreSQLDirect are you using?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby heafield » Mon 15 Oct 2007 09:22

Hi,
Latest version:
PgSQLDirect .NET 3.20 for .NET 2,
thanks
heafield
 
Posts: 5
Joined: Mon 15 Oct 2007 01:31

Postby Alexey » Mon 15 Oct 2007 09:36

Alexey wrote:Please describe the problem in detail.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
 
Posts: 5
Joined: Mon 15 Oct 2007 01:31

Postby 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
heafield
 
Posts: 5
Joined: Mon 15 Oct 2007 01:31

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL