PostgreSQL Native Provider
I'm in need of a functional OleDB data provider for PostgreSQL. It should be similar to the ODBC provider for MySQL. See http://dev.mysql.com/downloads/connector/odbc/5.1.html
PostgreSQL Native Provider (PGNP) is an OLEDB Provider for PostgreSQL database. The provider features support for Linked Servers, replication, DTS, SSIS and more. It can be used from 32-bit and 64-bit Windows applications both native and.NET.
3 Answers
The postgres software catalog has some providers on there.
dotConnect for PostgreSQL (from Devart) offers a pretty good one. It is fast and works. The free version will give you your basic ADO.net support, the pay offers everything else. ODBC doesn't have a free version.
http://www.devart.com/dotconnect/postgresql/
edit
Adding the direct link to the ODBC connector as it is on a separate page.
https://www.devart.com/odbc/postgresql/
Postgresql Native Provider Connection String
If you want to check the last version of ODBC for PosgreSQL :http://www.postgresql.org/ftp/odbc/versions/
Enter in the 'msi' folder for the installer.But be careful, when you are using ODBC, there is a 32bits and a 64bits version. Sewing machine repair shops near me. So choose the right one.