Обсуждение: Postgres Windows ADO help needed

Hello,
I have a linux box (Redhat 8.0) running postgresql and it works great.
 I would like to access the databases on this server from a windows
98/2000 client.  I had thought to use ODBC for this and have
experimented with the postgres ODBC driver and I have got this
working.

I am getting ready to develop some software using Borland's C++
builder 6.0 and have been reading about my options for database
access.  It seems like ODBC, while still an option, is being replaced
by ADO for future development.  It's even hard to find ODBC books at
the technical bookstore.  So, I have been looking into using ADO.

I have discovered that an ADO data server exists for postgres
(Npgsql).  It is not exactly clear to me how I download and install
this software on my windows machine.  It appears that it is now part
of mono--and I am not sure exactly what that means.

I have downloaded cygwin as a start to install mono, but I am not
clear why I would do this to install a windows routine.  I did notice
a link to download windows binaries on the mono web site, but this
link is broken--I get a German "file not found" error message.

Could someone be so kind as to help me out a little bit with this.

Thanks,
Greg Laird

On 8 Feb 2003 at 12:25, Greg Laird wrote:

> I am getting ready to develop some software using Borland's C++
> builder 6.0 and have been reading about my options for database
> access.  It seems like ODBC, while still an option, is being replaced

I've been writing stuff in Delphi which talks to a Postgres machine.
If you use ADO, you will need to use ODBC also as there is no native
OLE-DB driver for Postgres (that I'm aware of - please correct me if
I'm wrong). ADO talks to its generic OLE-DB driver for ODBC, which
talks to the Postgres ODBC driver, which talks to the database
machine.

I have found this works well, both for Win32 desktop clients and for
COM components called from ASP pages.

There is also a dbExpress driver for postgres available commercially
from www.vitavoom.com - I haven't tried it, but it might be worth
looking at.

--Ray.


-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------