Received: from bush.rutgersinsurance.com (rutgersinsurance.com [38.138.71.194]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA2I57l43322 for ; Thu, 2 Nov 2000 13:05:07 -0500 (EST) (envelope-from aalang@rutgersinsurance.com) Received: from 6014cwpza006 ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id NAA08637 for ; Thu, 2 Nov 2000 13:10:03 -0500 Message-ID: <002801c044f7$c08ab2e0$330a0a0a@6014cwpza006> From: "Adam Lang" To: References: <002801c044e8$780a0d40$330a0a0a@6014cwpza006> <00110209215001.14312@cncware.whidbey.com> Subject: Re: Connecting remotely - multi tier Date: Thu, 2 Nov 2000 13:07:24 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/45 X-Sequence-Number: 81 I know how to use a dll for VB, I just didn't know if there was a way to directly access the postgresql without using ODBC. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Ken J. Wright" To: "Adam Lang" ; Sent: Thursday, November 02, 2000 12:07 PM Subject: Re: [INTERFACES] Connecting remotely - multi tier > > In essence that is what I was asking... the possibility a Postgresql API > > that I could use, as opposed to a generalised ODBC driver. Whether for a > > client or a middle tier, it doesn't matter. > > That was your original question, and the answer is simply, use libpq.dll This > *is* the PostgreSQL API. If your windoze client app uses libpq.dll then you can > access a PostgreSQL database directly *without* the use of ODBC. The Zeos > components wrap up this functionality quite nicely for Delphi. I don't know > anything about using a .dll in VB so I can't help there, but that is just a > general VB issue that any experienced VB'er can answer. > > Ken