Hello again cdrick,

 

I believe you should be using the driver from http://map.squeak.org/package/a8d3ca99-f5f4-45e0-9aa7-100a77b64f45/autoversion/3

 

You should also load the cryptography package. You can either load the old one from squeakmap or the newer one from Monticello.  If you are loading the newer one use the HTTP repository

 

MCHttpRepository    location: 'http://www.squeaksource.com/Cryptography'    user: '’    password: ''

 

You will need a username and password on squeakSource.

 

Then load the Cryptography-Core, then the Cryptography-MD5 latest versions.  

 

The repository address for the PostgreSQL V2 driver is:

 

MCHttpRepository    location: 'http://www.squeaksource.com/PostgresV2'    user: ''    password: ''

 

I have not tried it myself but I know that Giovanni was going to http://lists.squeakfoundation.org/pipermail/squeak-dev/2005-January/087098.html  so maybe he can help with some pointers?

 

Also I noticed a package on Google (http://www.google.com/search?hl=en&q=postgres+squeak) http://www.io.com/~jimm/projects/squeak_postgresql/ but I don’t know anything about it.

 

Hope that helps,

 

Ron Teitelbaum

President / Principal Software Engineer

Really Geeky Guy

US Medical Record Specialists

Ron@USMedRec.com

 


From: beginners-bounces@lists.squeakfoundation.org [mailto:beginners-bounces@lists.squeakfoundation.org] On Behalf Of cdrick
Sent: Tuesday, May 09, 2006 11:08 AM
To: A friendly place to get answers to even the most basic questions aboutSqueak.
Subject: [Newbies] Postgress Database connection

 

Hi again...

I'm triing to connect to a remote postgres db without success...

I've use several framework

***Jim-PostgresSql ***

| client |
    client := PSQLClient new database: 'sup_prev'; user: 'web'.
    client establishConnection.
client closeConnection.

wich give an unknown message type $# (<- a square - maybe an encoding problem ?? )  aBiteArray(14)
in PSQLBackendMessage class>>readFrom: with:
... class := FactoryClassDict at: id ifAbsent: [self error: 'unknown message type ', id printString, ' (', id asInteger printString, ')'

***After, I've tryed PostgresV2***
something like... ( with configuration done on the class side: buildDefaultConnectionArgs )

|conn|
conn := PGConnection new.
conn .
conn startup.
conn execute: 'select * from experiences'.
conn terminate.
    ^ resultStream contents.
I get an error saying connection not valid - isConnected returning false :s
I probably missed something...

***After I tryied to use ODBC but without success too... :s   I don't know the dns for postgres...***

Can anyone tell me wich tool(package) to use preferably with postgres ? because I'm a bit lost at the moment :). Also, if you see what are the problems in my connections attempts

Thanks for all

Cédrick