How to configure iodbc access to local postgres db?
От | Rob Yampolsky |
---|---|
Тема | How to configure iodbc access to local postgres db? |
Дата | |
Msg-id | 3ADF257F.C826019F@cjds.com обсуждение исходный текст |
Список | pgsql-general |
I'm trying to get the iodbc driver manager to access postgres on the local machine with the odbctest tool that comes with the iodbc stuff. Having no luck. Fails on the connect attempt, and I know I'm doing something stupid, but don't know where to look. Help (or a good .odbc.ini) would be appreciated. Rob ryampols@cjds.com System is Mandrake 7.2 - postgres installed from RPM's on the MDK CD (libraries in /usr/lib, postgres home is /var/lib/pgsql). Logs this error in odbc.trace: SQLDriverConnect ( ... ) SQL_NO_DATA_FOUND My .odbc.ini file (accessed via ODBCINI env variable) looks like: [ODBC Data Sources] testdb = PostgreSQL test database [testdb] Driver = /usr/lib/libpsqlodbc.so.0 Description = PostgreSQL test database Host = localhost ServerType = postgres Port = 5432 FetchBufferSize = 99 UserName = Password = Database = testdb ServerOptions = ConnectOptions = Options = ReadOnly = no Trace = 1 TraceFile = /tmp/odbc.trace Debug = 1 DebugFile = /tmp/odbc.debug CommLog = 1
В списке pgsql-general по дате отправления: