Re: IM004-unixODBC

Hello

Tue, Mar 21, 2006 at 08:57:35PM +0100, juanudo@galeon.com napsal(a):
> I'm work on:
>           S.O.: Linux Suse 9.2
> PostgreSQL: 8
>   unixODBC: 2.2.10-3

I see no psqlodbc version.

> When a try to connect to PostgreSQL with ODBC:
> isql PostgreSQL user password -v
>
> suse:/etc/unixODBC # cat odbc.ini
> [ODBC Data Sources]
> PostgreSQL              = PostgreSQL ODBC 2.50
> Driver DSN
>
> [PostgreSQL]
> Description             = PostgreSQL
> Driver                    = PostgreSQL
> Trace                     = Yes
> TraceFile                = /tmp/sql.log
> Database                = GESTION
> Servername              = 167.175.51.178
> Username                = postgres
> Password                = XXXXXXXXXXXXX
  ^^^^^^^^
Don't include password next time.

> Port            = 5432
> Protocol                = 6.4
> ReadOnly                = No
> RowVersioning           = No
> ShowSystemTables                = No
> ShowOidColumn           = No
> FakeOidIndex            = No
> ConnSettings            =
> FileUsage               = 1

You could try add Debug = 1 and then you can see more in /tmp/*mylog*.
If there is no /tmp/*mylog* you have bad definition of psqlodbc driver.

Regards,

Luf