I am trying to import data from PostgreSQL database using ODBC Driver.
I have installed the ODBC driver and created a System DSN as required. The connection within the DSN is successfull.
However, when i trying to use the same credentails in the connection string, i am keep getting the error: "password authenticatio failer for user
The connection string used is as below:
Please let me know if i am missing something or doing something wrong.
Most of the connection information is included in the PostgreSQL ODBC setup. I believe you would need to reference your DSN here and you can drop the DB name and the server from the connection string