PostgreSQL ODBC OpenSource Drivers

[Pho3nix]

Hi all,

As per title, have any of you guys used a opensource and Free driver pack for PostgreSQL. The "official" one doesn't work and the alternatives are in the thousands of rands.
Any and all help is appreciated, trial versions of numerous apps are only getting back 100 rows which doesn't really work for me

 

[DRou]

What version of PostgreSQL are you using?

Edit: Are you using postgresql in conjunction with .net?

 

[Nod]

Are you sure the official ODBC drivers are not working?
http://stackoverflow.com/questions/6796252/setting-up-postgresql-odbc-on-windows
http://www.postgresql.org/ftp/odbc/versions/msi/

Are these instructions not working?

 

[Pho3nix]

What version of PostgreSQL are you using?

Edit: Are you using postgresql in conjunction with .net?

No idea. Latest drivers though as I need to connect to a remote DB.

Are you sure the official ODBC drivers are not working?
http://stackoverflow.com/questions/6796252/setting-up-postgresql-odbc-on-windows
http://www.postgresql.org/ftp/odbc/versions/msi/

Are these instructions not working?

Tried it and even asked another dev to look into it.
Official drivers work on my machine but on Dev and QA boxes it doesn't want to play.

Needed for SSIS job.

 

[DRou]

I know we use SSIS but with MSSQL, is it possible to try OleDB?
Maybe something in this link:
http://www.pgoledb.com/forum/viewtopic.php?f=4&t=2994

 

[Pho3nix]

Ended up having to create a webservice for the import.
Thanks all for your assistance.

Tool Used in Dev : https://www.nuget.org/packages/Npgsql if anyone ever want's to do the same.