Postgresql odbc column bytea problem

Hellow please,

Hi i have a aplication in visual basic 6. it connect to postgresql via odbc
driver 7.03.02.00.

the connection string its

strCn =
"DRIVER={PostgreSQL};DATABASE=prueba;SERVER=192.0.0.10;PORT=5432;UID=test;PWD=test;READONLY=0;PROTOCOL=7.x;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS="

well i create a table:

CREATE TABLE "public"."crypto" (
"campo1" BYTEA
) WITH OIDS;

and insert the data:

stsql = " insert into crypto(campo1) values (
encrypt('prueba', 'fooz', 'bf'))"

and its ok

but when do:
stSQL = "select decrypt(campo1, 'fooz', 'bf') as valor From crypto"

the result return say: ??

please any idea thank

--
Ing. Mario Soto Cordones
Venezolana de Avaluos

www.venezolanadeavaluos.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings