From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 Description of problem: To get PostgreSQL to work with unixODBC, I had to modify my /etc/odbcinst.ini: [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so.1 Setup = /usr/lib/libodbcpsqlS.so.1 This differs from most documentation on the web that state that /etc/odbcinst.ini should look more like this: [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so I also found out that I had to leave /etc/odbc.ini empty but that the .odbc.ini should be filled in to something like this: [ODBC Data Sources] TEMPLATE1 = Template Database [TEMPLATE1] Database = template1 Servername = localhost Debug = 1 CommLog = 1 ReadOnly = 0 Port = 5432 Driver = PostgreSQL Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. See above 2. 3. Actual Results: See above Additional info:
Fernando, please handle
Hi, You have to install the unixODBC-devel package as well. If you do this you don't have to specify the ".1"s. W.r.t. you .odb.ini file it seems to be working as expected. You must create a data source for the database you want to connect to (as with any ODBC). There are graphical tools to help you do that. Have you checked the html documentation that is installed in /usr/share/doc/unixODBC-2.2.3/doc ? Regards,
*** Bug 98575 has been marked as a duplicate of this bug. ***