RE: Querying Data From Oracle Database

[CHOWDARY SUBHASREE KOSARAJU]

Hi, Michel,

 

Thanks for the prompt reply.

I would like to know something more on how PSPP works with postgresql.

I have installed a windows version ‘setup-pspp-20100611.exe’ on my machine .  My OS is Windows XP.

 

I have tried using postgresql to connect to the database from pspp  like this

 

GET DATA /TYPE=PSQL

          /CONNECT='host=example.com port=5432 dbname=product user=fred passwd=xxxx'

          /SQL='select * from manufacturer'.

 

After giving all the information and I run the pspp syntax file I am getting an error

 

Error: support for reading postgres databases was not compiled into this installation of PSPP.

 

Could you please guide me how to connect this POSTGRES  thru PSPP?

 

 

Thanks & Regards

Subhasree

OMG-Asia Pte Ltd

 

From: Michel Boaventura [mailto:address@hidden
Sent: Monday, August 02, 2010 2:39 PM
To: NewbiePspp; address@hidden
Subject: Re: Querying Data From Oracle Database

 

Hello,

There is no way yet to query directly from oracle. So far PSPP only works with postgresql. I'm working on a module
which will make pspp able to connect to any base using ODBC, but so fair I didn't make much progress.

Just for your information, PSPP isn't a shareware. It is an open source software, released on GPL3 license.

Regards,

Michel