Hi, ALL, I successfully built the server and I previously had the odbc driver installed.
I can successfully connect from psql from the Terminal, and from isql unixODBC utility.
However, what I wonder is - is there a simple way to retrieve UsrerName and Password from odbc.ini file?
Below is my current configuration to connect.
WHat I'd like to do in my software is to get those parameters and use them in the "Connect To DB" dialog.
The easiest would probably be to save it in my local program configuration file, but in this case the information will be duplicated and I'd like to avoid it.
Grep the ini file, and add it to your local program's config file?
I sympathize with you about password duplication, though. My .pgpass files are chock full of duplicate passwords (primary server and multiple replication servers, plus server-name and server-name.example.com.
Regular expression parsing and case-insensitivity would make users (including DBAs) lives a lot easier.
