<span class="gmail_quote"></span><br><div><div><br>Hi Shaun :) <br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I'm a newbie too; but I have had success connecting to remote PG72
<br>DBs using Yanni Chiu's postgres client in Squakmap.<br><br>Here is some example code that works for me:<br><br>PGConnection defaultConnectionArgs<br> userName: '*******';<br> password: '******';<br> hostname: 'p-db-002';
<br> databaseName: 'trac'.<br><br>| db |<br>Transcript cr; show: 'Connecting to postgres'; cr.<br>db := PGConnection new.<br>(db startup; isConnected) ifTrue: [ | results |<br> results := db execute: 'select firstname, lastname from employee;'.
<br> results rows do: [ :row | | data |<br> data := row dataKeyedByFieldName.<br> Transcript show: 'First: ''', (data at: 'firstname') , ''''; cr.<br> Transcript show: 'Last: ''', (data at: 'lastname') , ''''; cr; cr].
<br> db terminate].</blockquote><div><br>Thanks for your code ;)<br>Actually, I found some problem but that was in the remote database...<br>I had an error message in the write buffer and I got an equivalent from my shell :s
<br><br></div><br></div>== psql: FATAL: Fichier pg_hba.conf manquant ou erroné<br>== HINT: Voir les traces du serveur pour plus de détails.<br><br>pg_hba.conf is missing or with errors ! I'll hope this is only that...<br>
It's postgress 7.4.7-6 sarge :)<br><br>see you<br><br>Cédrick<br><br>ps: for odbc, drivers have to be downloaded (from postgres) ...<br><br>