[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 dont 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