安装iODBC出问题

JohnBull

我安装了PostgrSQL,使用正常.
想实验iODBC,安装libiodbc 3.51.2和pgsqlodbc 7.3.0200
/etc/odbc.ini如下:

1. 
   
2. [ODBC Data Sources]
   
3. PgSQL = PostgreSQL ODBC Driver
   
4. 
   
5. [PgSQL]
   
6. Driver = /usr/local/lib/psqlodbc.so
   
7. Description = PostgreSQL Data Source
   
8. DSN = PgSQL
   
9. Servername = localhost
   
10. Port = 5432
    
11. ;Socket = 4096
    
12. Protocol = 7.2
    
13. UserName = ldap
    
14. Password = 1234
    
15. Database = pg_ldap
    
16. ReadOnly = no
    
17. ServerType = Postgres
    
18. FetchBufferSize = 99
    
19. ServerOptions =
    
20. ConnectOptions =
    
21. ;Options = 3
    
22. Trace = 0
    
23. TraceFile = /var/log/PostgreSQL_test_trace.log
    
24. Debug = 0
    
25. DebugFile = /var/log/PostgreSQL_test_debug.log
    
26. 
    
27. [Default]
    
28. Driver = /usr/local/lib/psqlodbc.so
    
29. Description = PostgreSQL Data Source
    
30. Server = localhost
    
31. Port = 5432
    
32. UserName = ldap
    
33. Password = 1234
    
34. ;Socket = 4096
    
35. ;end odbc.ini
    

复制代码

使用iodbctest测试的时候,输入DSN=PsSQL后程序再无响应.
不知何解?

idhly

/etc/services里有没有5432端口? 还有PG的访问授权是否设置正确?

JohnBull

PostgrSQL使用正常,so my pg_hba.conf should be correct.
I did't modify my /etc/services, but i'm not sure if it can help me. I'll try it tonight.

Thank you, however.