[Newbies] Postgress Database connection

Ron Teitelbaum Ron at USMedRec.com
Tue May 9 18:13:19 UTC 2006


Hello again cdrick,

 

I believe you should be using the driver from
http://map.squeak.org/package/a8d3ca99-f5f4-45e0-9aa7-100a77b64f45/autoversi
on/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.h
tml  so maybe he can help with some pointers?

 

Also I noticed a package on Google (http://www.google.com/search?hl=en
<http://www.google.com/search?hl=en&q=postgres+squeak> &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 at USMedRec.com 

 

  _____  

From: beginners-bounces at lists.squeakfoundation.org
[mailto:beginners-bounces at 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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/beginners/attachments/20060509/6087deef/attachment.htm


More information about the Beginners mailing list