PostgreSQL - how to connect without ODBC DSN creation?

[stary (Stanislaw R)]

Hi everyone,

I wonder, if there is a solution for a following case. In legacy version of my projects I used to use BalaReva PostgreSQL Activities ( Windows-Legacy compatibility) which worked perfectly, even without DSN in a ODBC Sources. After migration to Windows, I can not find other option than creating DSN in ODBC Sources. Does anyone know any option, where you DO NOT have to create DSN?

Thanks!

[KarthikByggari]

Hi @stary

I too faced the same situation for one of the projects.
I developed a small executable window program using C# (forms) as shown below.
I will open this program, connects to PgSQL and performs the required actions.
You can even develop these entirely in the backend with custom activity too.

Regards,
Kartheek Byggari

[stary (Stanislaw R)]

I found a solution, without using any form, you just use below connection string:
Driver={PostgreSQL UNICODE};Server=myServ;Port=5432;Database=myDb;Uid=userx;Pwd=xxx; and set “Provider Name” to “System.Data.Odbc”