I made an application in WPF that uses a postgres database. This is working fine locally.
I tried to upload the binaries to another machine, installed the ODBC driver, triple checked everything I could find on the internet, but I can't get it to work:
[ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
I checked the registry, I'm using a 64 bit machine and a 64 bit driver (psqlodbc_09_03_0300-x64-1) and I checked the connectionstring. I verified the driver name in the registry.
I setup a connection through ODBC (Data Sources) and tested the connection with the parameters. No problem there. PgAdmin III is also working just fine.
The only difference is that my local machine has postgres 9.1 and the remote machine postgres 9.4. (though they go to the same server which is 9.1)
If someone has some ideas, please share them.
thanks.
[SOLVED]
Go figure, the driver name should have been "{PostgreSQL UNICODE}" instead of "PostgreSQL Unicode(x64)" despite the registry telling me something else. I went back to the basics and used connectionstrings.com and just tried.
[/SOLVED]