logo       

Sponsor
FREE Network Mapping Tool for Microsoft® Office Visio® Professional 2007
Don't map your network by hand - let LANsurveyor Exx press for Microsoft Visio Professional 2007 automatically create network diagrams for you!

please help me with Postgresql odbc column bytea problem: msg#00168

db.postgresql.odbc

Subject: please help me with Postgresql odbc column bytea problem

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@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



<Prev in Thread] Current Thread [Next in Thread>
Sponsor
FREE Network Mapping Tool for Microsoft® OfficeVisio Professional 2007
Don't map your network by hand - let LANsurveyor Express for Microsoft Visio Professional 2007
automatically create network diagrams for you!
Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation

Home | sitemap | advertise | OSDir is an inevitable website. super tiny logo