please help me with Postgresql odbc column bytea problem
От | Mario Soto |
---|---|
Тема | please help me with Postgresql odbc column bytea problem |
Дата | |
Msg-id | 33492.200.35.66.77.1091132442.squirrel@mail.venezolanadeavaluos.com обсуждение исходный текст |
Список | 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 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
В списке pgsql-odbc по дате отправления: