Skip site navigation (1) Skip section navigation (2)

PLEASE HELP ME

From: "Mario Soto" <mario_soto(at)venezolanadeavaluos(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: PLEASE HELP ME
Date: 2004-07-31 18:00:39
Message-ID: 54157.200.35.66.77.1091296839.squirrel@mail.venezolanadeavaluos.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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





pgsql-odbc by date

Next:From: NH LauDate: 2004-08-02 08:52:13
Subject: VB getting image via odbc
Previous:From: Dave PageDate: 2004-07-30 19:27:00
Subject: Re: problem with CVS version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group