What is the connectionstring to connect with postgresql using ODBC driver?

Question

I am currently working with a task to connect with PostgreSQL and retrieve data from that DB to my .net application,I am using the code like

OdbcConnection con = new OdbcConnection("Driver={PostgreSQL };Server=localhost;Port=2012;Database=DataCenter;Uid=postgres;Pwd=post@123;");

but it is throwing an ODBException. Please suggest me a code.

What is the exact error message?

user330315
– user330315

2012-07-05 11:49:44 +00:00
Commented Jul 5, 2012 at 11:49 — user330315
– user330315, Commented Jul 5, 2012 at 11:49

Bgi · Accepted Answer · 2012-07-06 09:49:34Z

4

You may try that:

Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

You can definitely find more information on this website: http://www.connectionstrings.com/ And in your case particularely on this page: http://www.connectionstrings.com/postgre-sql#p51

If it does not solve your problem it is that the problem doesn't come from the connection string but your configuration of PostgreSQL. You might want to check that you're able to connect to the server using "psql" (for example) from your client computer.

Regards

answered Jul 6, 2012 at 9:49

Bgi

2,50414 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Metin Atalay · Accepted Answer · 2016-11-08 10:45:52Z

0

For Ex:

 string connstring = String.Format("Server={0};Port={1};User Id={2};Password={3};Database={4};",
                           "localhost", "5432", "postgres", "metin", "ATALAY");

answered Nov 8, 2016 at 10:45

Metin Atalay

1,52520 silver badges30 bronze badges

Collectives™ on Stack Overflow

What is the connectionstring to connect with postgresql using ODBC driver?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related