Re: How to configure iodbc access to local postgres db?
От | Hiroshi Inoue |
---|---|
Тема | Re: How to configure iodbc access to local postgres db? |
Дата | |
Msg-id | 3ADF8B28.20CCA089@tpf.co.jp обсуждение исходный текст |
Список | pgsql-general |
Rob Yampolsky wrote: > > 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 > Please try the following. 1) Use ~/.odbc.ini instead of ODBCINI. 2) psqlodbc driver doesn't see the 'Host' entry. Replace the 'Host' entry by 'Servername' entry. 3) Set a valid user name to the 'Username' Entry. 4) Remove blanks around '='. For example, Driver=/usr/lib/libsqlodbc.so.0 Good luck. Hiroshi Inoue > 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 по дате отправления: