I noticed while trying to figure out a problem that
GetPrivateProfileString(...) does it's string comparisons while reading
the ini file "case sensitive". This actuall turned out to be the reason
for my problem as the datasource was in the ini file as "postgresql" and
the program was telling the odbc driver to read the datasource
"POSTGRESQL" which it could not find cause it was doing the compares
case sensitive.
Is it written this way for a reason??? If not can it be changed to do a
strncmp?
Also as a note: If you are trying to get PostgreSQL + Coldfusion working
using the pgsql odbc driver make sure your datasource names are in all
uppercase in .odbc.ini as Coldfusion always passes the datasource name
in all caps.
Chris Ryan