Thread: please help me with Postgresql odbc column bytea problem

please help me with Postgresql odbc column bytea problem

From
"Mario Soto"
Date:
Hellow please,

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

my problem it is 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




---------------------------(end of broadcast)---------------------------
TIP 3: 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