From: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: Re: ODBC reading ini files
Date: Tue, 8 Aug 2000 15:06:29 -0500
Message-ID: <20000808150629.B5887@rice.edu> (raw)
In-Reply-To: <39906219.EF8002C2@greatbridge.com>
References: <39906219.EF8002C2@greatbridge.com>
On Tue, Aug 08, 2000 at 03:40:09PM -0400, Chris Ryan wrote:
> 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?
>
strncmp compares 'n' chars, rather than assuming null terminated. What your
looking for is strcasecmp. (Or stncasecmp)
> 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.
Hmm, I use PostgreSQL and Coldfusion, and all my datasource names are
lowercase. Works fine. I'm not using the ODBC driver that comes with
PostgreSQL however: I'm using the UnixODBC driver (that comes with CF)
What's your platform and CF version? I'm using Linux for both the database
and CF.
The only gotcha for me has been that it won't talk to localhost, I need
to use the FQDN of the system.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: reedstrm@rice.edu
Subject: Re: ODBC reading ini files
In-Reply-To: <20000808150629.B5887@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox