Im hosting a local postgres db and am trying to find open-source programs that will be able to connect to said db so that I can generate reports based on the data.
While I know Jasper is a thing, Im trying to see if there are alternatives and I came across 2:
Both of these ask for Connection Strings that Im not really familiar with.
Came across a site explaining it, but Im still unsure of the format.
Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;location=myDataBase;User ID=myUsername;password=myPassword;
Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Above are some of the examples the site provided with, but Im still confused. What is the Driver? What is the Provider? The site's examples werent cleared on what are these 2 are supposed to be.
I tried creating a Connection String based on the example:
Provider=PostgreSQLData;Data Source=jdbc:postgresql://localhost:5432/<myDBName>;location=<myDBName>;User ID=<myDBUsername>;password=<myDBPassword>;timeout=1000;
This fails. Something about Provider not found and Could not connect to database: Couldn't set provider