Re: your mail

On Sat, 9 Dec 2000, Aziz ABI wrote:

> Bonjour
> 
> Vous pouvez m'aider � cr�er une connexion ODBC � partir par un petit
> module VB.
> 
> Merci
> 

Sure.

1. Set your pg_hba.conf to allow access from your Windows machine.
2. Install the ODBC driver for PostgreSQL on that machine.
3. Set up an ODBC DSN using that driver.
4. Here's some sample VB code to talk to the database using the DSN:
   Dim rs As ADODB.Recordset   Dim cn As String   Dim rc As Variant   Dim r, c As Integer   Set rs = New
ADODB.Recordset  cn = "DSN=pgtest;UID=moi;DATABASE=test"   rs.Open "SELECT * FROM t", cn, , , 1   Do While Not rs.EOF
   rc = rs.GetRows       For r = 0 To UBound(rc, 2)           For c = 0 To UBound(rc, 1)               Debug.Print r &
"" & c " " & rc(c, r)           Next c       Next r   Loop
 

Hope this help.

-- 
Bob Kline 
mailto:bkline@rksystems.com 
http://www.rksystems.com