encyption database access

jeffs · #1 (**permalink**) 03-17-04, 12:07

I am trying to use odbc to connect to an encrypted database. I have the key, but I do not know how to use it to get in. Any help would be appreciated.

Thanks

mirtheil · #2 (**permalink**) 03-17-04, 12:39

What version of Pervasive are you using? You might try the SET OWNER statement:
SET OWNER="ownername"

jeffs · #3 (**permalink**) 03-17-04, 12:56

I am using 2000I.

mirtheil · #4 (**permalink**) 03-17-04, 14:40

I tried with SP4 2000i and using the PCC, was able to do the following:
SET OWNER="owner"#
select * from encryptedtable
Once I ran the Set Owner, I was able to read the table.

Internet Services

Web Development

Digital Marketing

Consumer Tech