<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
 namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
 name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hello again cdrick,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I believe you should be using the driver
from <a
href="http://map.squeak.org/package/a8d3ca99-f5f4-45e0-9aa7-100a77b64f45/autoversion/3">http://map.squeak.org/package/a8d3ca99-f5f4-45e0-9aa7-100a77b64f45/autoversion/3</a>
<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You should also load the cryptography
package. You can either load the old one from squeakmap or the newer one from <st1:State
w:st="on"><st1:place w:st="on">Monticello</st1:place></st1:State>. áIf you are
loading the newer one use the HTTP repository <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>MCHttpRepositoryááá location:
'http://www.squeaksource.com/Cryptography'ááá user: '&#8217;ááá password: ''<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You will need a username and password on
squeakSource.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Then load the Cryptography-Core, then the
Cryptography-MD5 latest versions. á<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The repository address for the PostgreSQL
V2 driver is: <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>MCHttpRepositoryááá location:
'http://www.squeaksource.com/PostgresV2'ááá user: ''ááá password: '' <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I have not tried it myself but I know that
Giovanni was going to <a
href="http://lists.squeakfoundation.org/pipermail/squeak-dev/2005-January/087098.html">http://lists.squeakfoundation.org/pipermail/squeak-dev/2005-January/087098.html</a>
áso maybe he can help with some pointers?<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Also I noticed a package on Google (<a
href="http://www.google.com/search?hl=en&amp;q=postgres+squeak">http://www.google.com/search?hl=en&amp;q=postgres+squeak</a>)
<a href="http://www.io.com/~jimm/projects/squeak_postgresql/">http://www.io.com/~jimm/projects/squeak_postgresql/</a>
but I don&#8217;t know anything about it.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hope that helps,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Ron Teitelbaum<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>President / Principal Software Engineer<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Really Geeky Guy<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>US Medical Record Specialists<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a href="mailto:Ron@USMedRec.com">Ron@USMedRec.com</a>
<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> beginners-bounces@lists.squeakfoundation.org
[mailto:beginners-bounces@lists.squeakfoundation.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>cdrick<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, May 09, 2006 11:08
AM<br>
<b><span style='font-weight:bold'>To:</span></b> A friendly place to get
answers to even the most basic questions aboutSqueak.<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Newbies] Postgress
Database connection</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Hi again...<br>
<br>
I'm triing to connect to a remote postgres db without success...<br>
<br>
I've use several framework<br>
<br>
***Jim-PostgresSql ***<br>
<br>
| client |<br>
&nbsp;&nbsp;&nbsp; client := PSQLClient new database: 'sup_prev'; user: 'web'. <br>
&nbsp;&nbsp;&nbsp; client establishConnection.<br>
client closeConnection.<br>
<br>
wich give an unknown message type $# (&lt;- a square - maybe an encoding
problem ?? )&nbsp; aBiteArray(14)<br>
in PSQLBackendMessage class&gt;&gt;readFrom: with: <br>
... class := FactoryClassDict at: id ifAbsent: [self error: 'unknown message
type ', id printString, ' (', id asInteger printString, ')'<br>
<br>
***After, I've tryed PostgresV2***<br>
something like... ( with configuration done on the class side:
buildDefaultConnectionArgs ) <br>
<br>
|conn|<br>
conn := PGConnection new.<br>
conn .<br>
conn startup.<br>
conn execute: 'select * from experiences'.<br>
conn terminate.<br>
&nbsp;&nbsp;&nbsp; ^ resultStream contents.<br>
I get an error saying connection not valid - isConnected returning false :s <br>
I probably missed something...<br>
<br>
***After I tryied to use ODBC but without success too... :s&nbsp;&nbsp; I don't
know the dns for postgres...***<br>
<br>
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 <br>
<br>
Thanks for all<br>
<br>
CÚdrick<br>
<br>
<o:p></o:p></span></font></p>

</div>

</div>

</body>

</html>