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 <bstj...@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.al...@gmail.com> > *To:* Benoit St-Jean <bstj...@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.al...@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.al...@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 ? > > > > >
