Received: from ns1.engrs.org (ns1.engrs.org [216.54.29.10])
	by hub.org (8.10.1/8.10.1) with ESMTP id e78JgUG95154
	for <pgsql-interfaces@postgresql.org>;
	Tue, 8 Aug 2000 15:42:30 -0400 (EDT)
Received: (from uucp@localhost) by ns1.engrs.org (8.9.3/8.9.3) id PAA32304
	for <pgsql-interfaces@postgresql.org>; Tue, 8 Aug 2000 15:52:19 -0400
Received: from UNKNOWN(216.54.29.80), claiming to be "greatbridge.com"
	via SMTP by ns1.engrs.org, id smtpdgDCdeV; Tue Aug  8 19:52:10 2000
Message-ID: <39906219.EF8002C2@greatbridge.com>
Date: Tue, 08 Aug 2000 15:40:09 -0400
From: Chris Ryan <chris@greatbridge.com>
Organization: GreatBridge LLC
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-6.1.1 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: ODBC reading ini files
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200008/65

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