From: Gerald Gryschuk <ggryschuk@scf.sk.ca>
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
Cc: Byron Nikolaidis <byronn@insightdist.com>
Cc: Postgres Interfaces Mailing List <pgsql-interfaces@postgreSQL.org>
Cc: Postgres Documentation List <docs@postgreSQL.org>
Subject: Re: [INTERFACES] postodbc on sparc2.5.1
Date: Thu, 03 Sep 1998 11:53:46 -0600
Message-ID: <35EED7AA.A03C991A@scf.sk.ca> (raw)
References: <19980902101454994-89c6e9f4@cfipro.com>
<35EE01A7.B204EEA7@alumni.caltech.edu>
<35EEAF94.3195011@scf.sk.ca>
<35EEB421.BB93DFAE@alumni.caltech.edu>
Thomas G. Lockhart wrote:
>
> > ... maybe you should include your .odbc.ini
> > file with the distribution as an example. Obviously it wouldn't work
> > for other people but at least they
> > might have a better idea of what to put in it.
>
> I've written some sgml docs which include these files as examples. The
> examples are necessary. The combination of section labels required by
> iodbc and psqlodbc for the odbcinst.ini and odbc.ini files is not
> particularly obvious or consistant. In particular, psqlodbc requires a
> section label 'PostgreSQL' in the odbcinst.ini file while iodbc requires
> a label of 'Default' for driver info in .odbc.ini afaik.
iodbc doesn't NEED the 'Default' label but if no other DSN entry is
given when
SQLDriverConnect is called than iodbc uses the 'Default' entry. At least
this is what
should happen if the last parameter to SQLDriverConnect is set to
SQL_DRIVER_NOPROMPT.
If the last parameter is anything else and the DSN ISN'T specificied,
iodbc SHOULD bring up a dialog box which presumably would allow the user
to select a DSN source from their .odbc.ini file. Unfortunately the
function that is supposed to do this called '_iodbcdm_drvconn_dialbox'
is not in iodbc-2.12 and thus the SQLDriverConnect call should fail in
this case, at least that's my reading of the code(see SQLDriverConnect
in file connect.c of iodbc).
Any volunteers for writing this function? I was going to doing something
with this since psqlodbc needs(wants) something similar to allow the
user to change the settings for a specific DSN when its SQLDriverConnect
is called, I just never got around to it.
--
Gerald Gryschuk(ggryschuk@scf.sk.ca)
Programmer Analyst
Saskatoon Cancer Centre
((306)655-2746)
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: ggryschuk@scf.sk.ca, lockhart@alumni.caltech.edu, byronn@insightdist.com, docs@postgreSQL.org
Subject: Re: [INTERFACES] postodbc on sparc2.5.1
In-Reply-To: <35EED7AA.A03C991A@scf.sk.ca>
* 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