Skip site navigation (1) Skip section navigation (2)

psqlODBC driver does not work

From: "Yury Koles" <fresh_impression(at)hotmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlODBC driver does not work
Date: 2004-05-14 06:41:04
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
I've problem getting the psqlODBC driver and ODBC in
general to work on RedHat 9. I've built and installed
PostgreSQL ver. 7.4.2, unixODBC driver manager
ver. 2.2.8, and psqlODBC driver ver. 07.03.0200 without
errors.  In the documentation I've seen that the
driver's name is, but I cannot find anywhere on the system.  The psqlODBC
distribution builds '' and ''.  I
tried using '' in 'odbcinst.ini' as a value
of the 'Driver' field, but I could not connect to my
database using 'isql', namely, once I type the command

isql -v examples_ODBC userfoo passwd

and press ENTER 'isql' hangs and I have to kill it with

Could somebody point me in the right direction.  I
don't even sure of the right library name.  EVEN SHORT

	   If relevant, this is the log of this run:
conn = 134628032, PGAPI_Connect(DSN='examples_ODBC',
UID='userfoo', PWD='xxxxx') Global Options:
Version='07.03.0200', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254,
                disable_optimizer=1, ksqo=1,
                unique_index=1, use_declarefetch=0
                bools_as_char=1 NAMEDATALEN=64
                conn_settings='' conn_encoding='OTHER'
conn=134628032, query=' '
---(END OF) psqlodbc_userfoo626.log--------------------

I've built ODBC driver from unixODBC distribution:
'' and connected using that one with
isql.  I could run queries, but 'isql' hangs and has to
be killed with ^C as described above once I enter
'quit' on its prompt.  Moreover, I could connect
if I set authentication in 'pg_hba.conf' for 'local'
and 'host' to 'trust' or 'passwd', but connection fails
if I set it to 'crypt' or 'md5'.

		 If relevant, here are my '.ini' files:
Description	= unixODBC for PostgreSQL
Driver = /usr/local/lib/
Setup = /usr/local/lib/
FileUsage	= 1
CommLog = 1
Debug = 1
---end of odbcinst.ini-----

[ODBC Data Sources]
examples_ODBC = Database Examples

Database = examples
Description	= Various tutorial examples
ReadOnly = No
Servername = localhost
Port = 5432
Protocol = 7.4
Driver = PostgreSQL_unixODBC
Username =
Password =
Trace = Yes
Tracefile = /tmp/unixODBC.log
CommLog = 1
Debug = 1
---end of .odbc.ini-----

Getting married? Find tips, tools and the latest trends at MSN Life Events.


pgsql-odbc by date

Next:From: Bob WoodsideDate: 2004-05-14 20:31:55
Subject: Re: psqlODBC driver does not work
Previous:From: Martin PittDate: 2004-05-13 23:52:29
Subject: Re: Fix for buffer overflow ready [was: Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)]

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group