Click here to Skip to main content
16,016,306 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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]
Posted
Updated 24-Jun-15 2:32am
v2

1 solution

[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]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900