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: BAY16-F5F1HkikieqXI0000b74e@hotmail.com (view raw or flat)
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 libpsqlodbc.so, but I cannot find
libpsqlodbc.so anywhere on the system.  The psqlODBC
distribution builds 'psqlodbc.so' and 'psqlodbc.la'.  I
tried using 'psqlodbc.so' 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
^C.

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

	   If relevant, this is the log of this run:
---psqlodbc_userfoo626.log-----------------------------
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,
max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1,
                unique_index=1, use_declarefetch=0
                text_as_longvarchar=1,
                unknowns_as_longvarchar=0,
                bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;',
                conn_settings='' conn_encoding='OTHER'
conn=134628032, query=' '
---(END OF) psqlodbc_userfoo626.log--------------------

I've built ODBC driver from unixODBC distribution:
'libodbcpsql.so' 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:
------odbcinst.ini---------
[PostgreSQL_unixODBC]
Description	= unixODBC for PostgreSQL
Driver = /usr/local/lib/libodbcpsql.so
Setup = /usr/local/lib/libodbcpsqlS.so
FileUsage	= 1
CommLog = 1
Debug = 1
---end of odbcinst.ini-----

---.odbc.ini---------------
[ODBC Data Sources]
examples_ODBC = Database Examples

[examples_ODBC]
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. 
http://lifeevents.msn.com/category.aspx?cid=married


Responses

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-2014 The PostgreSQL Global Development Group