Re: your mail

On Sat, 9 Dec 2000, Aziz ABI wrote:

> Bonjour
>
> Vous pouvez m'aider crer 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(at)rksystems(dot)com
http://www.rksystems.com