From: Justin M. Mahoney <gumbytwo@mindless.com>
To: pgsql-interfaces@postgresql.org
Subject: Can't get any ODBC under linux-i386
Date: Tue, 27 Jul 1999 15:00:23 -0700
Message-ID: <379E2BF7.5048DABE@mindless.com> (raw)
Hi. I've compiled PostgreSQL 6.5.1 onto my Redhat 6.0 box with iodbc
2.50-3.
I have my ODBCINI set to /etc/odbc.ini
I have a ~/.odbc.ini file which is a copy of odbc.ini.
I can't get it to work locally or remote.
Here's my odbc.ini:
===================================
[ODBC Data Sources]
OnlyInLATest = OnlyInLA.com test database
[OnlyInLATest]
Database = onlyinla
Username = pguser
Password = xxxx
[Default]
Servername = lethe
Port = 5432
Driver = /usr/postgres/lib/libpsqlodbc.so
===================================
And here's the output of odbctest in the samples/ directory of the
libiodbc dist.:
===================================
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
Enter ODBC connect string (? shows list): OnlyInLATest
[iODBC][Driver Manager]Dialog failed, SQLSTATE=IM008
Have a nice day.
===================================
The postgres odbc driver directory is included in my /etc/ld.so.conf
file and linked in with ldconfig, as is the /usr/local/lib directory
containing my iodbc driver.
I always get the same error message. Am I missing some config. item?
If anybody has a working ODBC setup with postgres, could they just
please post what they are using (distribution names and versions)?
I emailed a Mr. Daren Sefcik who was having the same problem on Solaris
2.6, but his fixes (linking in extra libs in Makefile.shlib) didn't work
for me.
Thanks so much.
Justin
gumbytwo@mindless.com
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: gumbytwo@mindless.com
Subject: Re: Can't get any ODBC under linux-i386
In-Reply-To: <379E2BF7.5048DABE@mindless.com>
* 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