It took me some time to determine a good connection string to connect to PostgreSQL. Yes, the DSN or the dotNet connections strings are pretty well defined at many sites, but I couldn't locate a good reference for a DSN-less connection string.

After a lot of trial and error, I finally managed to get one that worked. Check out these; they work for me...

Now, tracking down a connection string CAN be painful. Ref this tutorial in our sister site, Xtreme VB Talk, for a few approaches to creating that perfect connection string....

If you prefer to download a finished utility, one based on the above code is available here.