no conn connect does not work because GAConnection has no such method. #connect exist in GAPostgresDrive but even if I go that route I get error #OptionAt:IfAbsent: was sent to nil . With this code conn2 := GAPostgresDriver new . conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' port: '****' database:'*******' user: '*****' password:''***'. conn2 connect. Is there sample code that connects to online databases ? On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstjean@yahoo.com> wrote:
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 ?