psqlODBC driver does not work
От | Yury Koles |
---|---|
Тема | psqlODBC driver does not work |
Дата | |
Msg-id | BAY16-F5F1HkikieqXI0000b74e@hotmail.com обсуждение исходный текст |
Ответы |
Re: psqlODBC driver does not work
|
Список | 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
В списке pgsql-odbc по дате отправления: