PostgreSQL Database and Reporting Service?

Hello all -
I have reporting services installed on SQL server 2000 database and have
developed many many great reporrts on it.
However, I have the need now to address datasources from PostgreSQLdatabase
open-source database and I wonder if RS would work with PostgreSQL ODBC and
if the only thing I need is to establish an ODBC connection to the database?
Thanks for the info in advance.
wise -
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1you can always make linked servers to the postgres database; and then
setup some queries as views on the SQL Server side..
then you're doing RS against SQL 2000 which is calling queries on
postgres
-Aaron
wiseteufel via SQLMonster.com wrote:
> Hello all -
> I have reporting services installed on SQL server 2000 database and have
> developed many many great reporrts on it.
> However, I have the need now to address datasources from PostgreSQLdatabase
> open-source database and I wonder if RS would work with PostgreSQL ODBC and
> if the only thing I need is to establish an ODBC connection to the database?
> Thanks for the info in advance.
> wise -
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1|||thanks dbaHooker .. i will try that. will see what drivers postgres has!!
dbahooker@.hotmail.com wrote:
>you can always make linked servers to the postgres database; and then
>setup some queries as views on the SQL Server side..
>then you're doing RS against SQL 2000 which is calling queries on
>postgres
>-Aaron
>> Hello all -
>[quoted text clipped - 12 lines]
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200609/1