Connection String Problem to postgresql from C# application

I am trying to connect to a Local postgresql Database Version 9.5.1
from a C# application

My connection String and call statement are shown below:

using (IDbConnection connection = new System.Data.OleDb.OleDbConnection(GlobalConfig.CnnString(db)))

At Run time I get the error:

System.Data.OleDb.OleDbException: 'Login failed for user 'postgres'.
Invalid connection string attribute'

What is wrong with my connection string



1 answer

Can you use ODBC Data Source Admin to setup a User DSN to your DB and test the connection?