05-20-2012, 09:05 PM
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:
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.
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.
