IM004-unixODBC

I'm work on:
S.O.: Linux Suse 9.2
PostgreSQL: 8
unixODBC: 2.2.10-3

#rpm -aq | greo unixODBC
unixODBC-devel-2.2.10-3
qt3-unixODBC-3.3.4-11
unixODBC-gui-qt-2.2.10-3
unixODBC-2.2.10-3
php4-unixODBC-4.3.10-14

When a try to connect to PostgreSQL with ODBC:
isql PostgreSQL user password -v

The ODBC say me:
[IM004][unixODBC][Driver Manager]Driver's=20
SQLAllocHandle on SQL_HANDLE_HENV failed

my config are:

suse:/usr/lib/unixODBC # odbcinst -j
unixODBC 2.2.10
DRIVERS............: /etc/unixODBC/odbcinst.ini
SYSTEM DATA SOURCES: /etc/unixODBC/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini

suse:/etc/unixODBC # cat odbc.ini
[ODBC Data Sources]
PostgreSQL =3D PostgreSQL ODBC 2.50=20
Driver DSN

[PostgreSQL]
Description =3D PostgreSQL
Driver =3D PostgreSQL
Trace =3D Yes
TraceFile =3D /tmp/sql.log
Database =3D GESTION
Servername =3D 167.175.51.178
Username =3D postgres
Password =3D d,sm_dymr
Port =3D 5432
Protocol =3D 6.4
ReadOnly =3D No
RowVersioning =3D No
ShowSystemTables =3D No
ShowOidColumn =3D No
FakeOidIndex =3D No
ConnSettings =3D
FileUsage =3D 1




Any body know what happed?

Atentamente, Juan Mosqueda.
Constructor de Exitos.
Te alcanzan tus ingresos? te invito a=20
desarrollar tu propio negocio. 058-0414-0932538
Linux Counter #145635
------------------------------------------------------------ -------------=
----------
Di adi=F3s a los virus y a los pop-ups
http://barra.hispavista.com/hispavista/cargar.html

------------------------------------------------------------ -------------=
----------
=BFConoces eBay, el mayor centro de compra y venta en internet?
M=F3viles, port=E1tiles, pda=B4s, cd=B4s, c=E1maras digitales, videocamar=
as...
=A1Compra ahora a los mejores precios! http://ebay.hispavista.com/
------------------------------------------------------------ -------------=
----------
=BFCompras por internet?
http://compras.hispavista.es/

------------------------------------------------------------ -------------=
----------
- Correo seguro con tecnolog=EDa Panda Software


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: IM004-unixODBC

>I see no psqlodbc version.

I'm using psqlODBC-07.03.0200-85 and=20
unixODBC-2.2.10-3.

>... you have bad definition of psqlodbc driver.

What i can do for know when the definition is=20
bad?


Atentamente, Juan Mosqueda.
Constructor de Exitos.
Te alcanzan tus ingresos? te invito a=20
desarrollar tu propio negocio. 058-0414-0932538
Linux Counter #145635
------------------------------------------------------------ -------------=
----------
Di adi=F3s a los virus y a los pop-ups
http://barra.hispavista.com/hispavista/cargar.html

------------------------------------------------------------ -------------=
----------
=BFConoces eBay, el mayor centro de compra y venta en internet?
M=F3viles, port=E1tiles, pda=B4s, cd=B4s, c=E1maras digitales, videocamar=
as...
=A1Compra ahora a los mejores precios! http://ebay.hispavista.com/
------------------------------------------------------------ -------------=
----------
=BFCompras por internet?
http://compras.hispavista.es/

------------------------------------------------------------ -------------=
----------
- Correo seguro con tecnolog=EDa Panda Software


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: IM004-unixODBC

Oh, I am sorry very late reaction....

----- Original Message -----
From: juanudo


> [PostgreSQL]
> Description = PostgreSQL
> Driver = PostgreSQL

Probably,does the following help you?
Driver = /usr/lib/psqlodbc.so

However, please specify a suitable place.

Regards,
Hiroshi Saito


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: IM004-unixODBC

Thank you some much Hiroshi, that is the=20
problem. I=B4m change

> Driver =3D PostgreSQL
for
>Driver =3D /usr/lib/psqlodbc.so

in my odbc.ini and connecting work.=20

When the unixODBC stiil does not work but=20
psqlodbc.so solve me problem.


Atentamente, Juan Mosqueda.
Constructor de Exitos.
Te alcanzan tus ingresos? te invito a=20
desarrollar tu propio negocio. 058-0414-0932538
Linux Counter #145635
------------------------------------------------------------ -------------=
----------
Di adi=F3s a los virus y a los pop-ups
http://barra.hispavista.com/hispavista/cargar.html

------------------------------------------------------------ -------------=
----------
=BFConoces eBay, el mayor centro de compra y venta en internet?
M=F3viles, port=E1tiles, pda=B4s, cd=B4s, c=E1maras digitales, videocamar=
as...
=A1Compra ahora a los mejores precios! http://ebay.hispavista.com/
------------------------------------------------------------ -------------=
----------
=BFCompras por internet?
http://compras.hispavista.es/

------------------------------------------------------------ -------------=
----------
- Correo seguro con tecnolog=EDa Panda Software


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match