Connection String for Postgres SQL

[Scott]

I am trying to connect to a PostgreSQL database.  Has anybody ever done this and if so can you please share your Connection String?

I am using this:

User ID=postgres;Password=myPass;Host=//xx.xx.xx.x;Port=5432;Database=my_db;

Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;

and I am getting this error:

• [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Thanks in advance!!!!

Scott

[couch]

I have not used Postgres, but just FYI, in addition to the connection string, you will also have to install a 64-bit (assuming you are using v9 or later xmpie) Postgres ODBC driver on the computer where XMPie is using the connection string.