VB and ODBC - Mailing list pgsql-interfaces

From Graham Vickrage
Subject VB and ODBC
Date
Msg-id NDBBJABDILOPAOOMFJHOOEKACJAA.graham@digitalplanit.com
Whole thread Raw
List pgsql-interfaces
I am a new to ODBC and relatively new to VB. I am trying to make a
connection to a postgres 7.0 DB from word via a VB macro. I think I have
installed the ODBC driver correctly (win98) and am trying to make a
connection via the VB module using the following.

Sub ClientOrder()   With ActiveDocument.MailMerge       .MainDocumentType = wdFormLetters       constr =
"DSN=PostgreSQL;"_                & "FIL=RedISAM;"      .OpenDataSource Name:="dbname", _      Connection:=constr,
SQLStatement:="SELECTClient_order_id FROM
 
client_order"   End With
End Sub

This does not work I think because of the .OpenDataSource Name:="dbname". In
other examples (ie access) it points directly the the DB File ie
'c:/somefile.mdb'. How would this work for postgres, is there an equivilant
on the linux box (I think not). Or could someone point me to some examples
of this.

Thanks in advance

Graham



pgsql-interfaces by date:

Previous
From: liam
Date:
Subject: Re: MS Windows libpq++
Next
From: "Michael Ansley (UK)"
Date:
Subject: RE: VB and ODBC