You have to #connect before executing SQL statements!

Something like (in your code):

conn connect.
 
-----------------
Beno��t St-Jean
Yahoo! Messenger: bstjean
Twitter: @BenLeChialeux
Pinterest: benoitstjean
Instagram: Chef_Benito
IRC: lamneth
Blogue: endormitoire.wordpress.com
"A standpoint is an intellectual horizon of radius zero".  (A. Einstein)


From: Dimitris Chloupis <kilon.alios@gmail.com>
To: Benoit St-Jean <bstjean@yahoo.com>; Any question about pharo is welcome <pharo-users@lists.pharo.org>
Sent: Monday, April 17, 2017 3:54 PM
Subject: Re: [Pharo-users] PostgreSQL and Pharo 6

Installing from Catalog Browser fails

I installed it via the the website instructions, it installs fine

But if I use it this way 

conn := GAConnection new.
ca := GAConnectionArgs hostname: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' 
portno: '****'
databaseName:'*******'  
userName: '*****'  
password:''***'.
conn connectionArgs: ca.
conn execute: 'select * from search_terms'.

it fails with no connection, is there anything else i need to do ?
is there a guide for how to use this ? 



On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.alios@gmail.com> wrote:
thank you Benoit 

On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users <pharo-users@lists.pharo.org> wrote:
ODBC worked fine as well if you don't need native driver access
 
-----------------
Beno��t St-Jean
Yahoo! Messenger: bstjean
Twitter: @BenLeChialeux
Pinterest: benoitstjean
Instagram: Chef_Benito
IRC: lamneth
Blogue: endormitoire.wordpress.com
"A standpoint is an intellectual horizon of radius zero".  (A. Einstein)


From: Dimitris Chloupis <kilon.alios@gmail.com>
To: Any question about pharo is welcome <pharo-users@lists.pharo.org>
Sent: Sunday, April 16, 2017 4:37 AM
Subject: [Pharo-users] PostgreSQL and Pharo 6

Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D

I am using Python for it but I would like to give access also to Pharo to my database. I was informed that Garage has a driver for PostgreSQL , is there any other candidate ? Any advice ?