From: | "Mario Soto" <mario_soto(at)venezolanadeavaluos(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | please help me with Postgresql odbc column bytea problem |
Date: | 2004-07-29 20:20:42 |
Message-ID: | 33492.200.35.66.77.1091132442.squirrel@mail.venezolanadeavaluos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
---------------------------(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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-07-30 07:39:14 | Re: problem with CVS version |
Previous Message | Janet Borschowa | 2004-07-29 19:22:10 | Re: problem with CVS version |