Connection string doesnt work for PostgreSQL

Question

I am using the following connection string structure in my web.config in order to connect to a PostgreSQL database using ODBC however I get an error:

Connection string

<add name="ApplicationODBCDefault" connectionString="Driver={PostgreSQL};Server=127.0.0.1;Port=5432;Database=dbname;Uid=name;Pwd=password;"/>

Error:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have downloaded and installed both the 32 bit and 64 bit drivers for PostgreSQL ODBC from Here and it still isn't working. What could be the issue here?

Could you try if your connection works with ODBC Manager? And just to ask. Why not use npgsql managed provider? — Steve
– Steve, Commented Apr 2, 2012 at 11:09
Where can I find this? Npgsql cannot be used as the solution must be database agnostic. Long story. Tried the OLE route but couldnt get Npgsql to play nice with OLE. ODBC is the next route I want to explore. — CSharpened
– CSharpened, Commented Apr 2, 2012 at 11:11

Michał Niklas · Accepted Answer · 2020-03-04 06:06:17Z

1

Instead of {PostgreSQL} use {PostgreSQL ANSI} or {PostgreSQL UNICODE}

Driver={PostgreSQL UNICODE};Server=127.0.0.1;Port=5432;Database=dbname;Uid=name;Pwd=password;

for more connection strings have a look at: http://www.connectionstrings.com/postgre-sql

You can also configure DSN using ODBC Data Source Administrator and then use created DSN name in ConnectionString:

DSN=dsn_name;Uid=name;Pwd=password;

Look at: https://www.connectionstrings.com/odbc-dsn/

edited Mar 4, 2020 at 6:06

answered Apr 3, 2012 at 8:18

Michał Niklas

54.5k19 gold badges77 silver badges125 bronze badges

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

3 Comments

PiotrKowalski Over a year ago

With this I got "Keyword not supported: driver". Any ideas why? My code looks like this: "Driver={PostgreSQL UNICODE};Server=*****;Port=5432;Database=IdM_Person;Uid=Guest;Pwd=******;"

Elias Ghali Over a year ago

Hey, I keep getting this error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, although if I use Server Explorer, it connects using PostgreSQL driver, but not with this connection string !

Michał Niklas Over a year ago

I added info about using DSN. It may be easier.

lexes · Accepted Answer · 2014-08-20 00:00:01Z

1

If you are using the 64 bits version of PostgreSQL, then you should use in the connection string:

Driver={PostgreSQL UNICODE(x64)};Server=127.0.0.1; .......

answered Aug 20, 2014 at 0:00

lexes

111 bronze badge

1 Comment

Pamungkas Jayuda Over a year ago

If we develop with X64, use this code work well. How about i build this code and use at i386 ?

Collectives™ on Stack Overflow

Connection string doesnt work for PostgreSQL

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related