Cannot connect to PostgreSQL (ODBC data source)

[rothe]

I created ODBC Datasource (name PostgreSQL35W, driver PostgreSQL Unicode (x64)) and tested successfully. Now I tried to use that in QM but failed constantly (tried some of the examples in this forum). My database open looks like:

Code:

Copy      Help

Database db.Open("ODBC;Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;DATABASE=testdatabase;Uid=postgres;Pwd=xxxxxx;")

The error that I am getting is:
Error (RT) in query_to_db: 0x80004005, Unspecified error.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. ?

My main goal is to connect to PostgreSQL database with or without ODBC. I am using Windows 7 64bit.

[Gintaras]

http://www.connectionstrings.com/postgre-sql#p53
http://www.connectionstrings.com/postgre-sql#p51

[rothe]

Thank you! Got connection.