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