Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Decrypt a Table from VFP !!

4 posts in FoxPro Last posting was on 2008-05-23 15:30:54.0Z
Hugo Posted on 2008-05-23 03:48:35.0Z
From: "Hugo" <gomh7172@hotmail.com>
Newsgroups: advantage.foxpro
Subject: Decrypt a Table from VFP !!
Date: Thu, 22 May 2008 22:48:35 -0500
Lines: 15
Organization: Cibernetica de Mexico
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 189.165.45.37
Message-ID: <48363d31@solutions.advantagedatabase.com>
X-Trace: 22 May 2008 21:42:41 -0700, 189.165.45.37
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.165.45.37
Xref: solutions.advantagedatabase.com Advantage.FoxPro:254
Article PK: 1109608

Hi,

Somebody Can Help me ?,
How Can I Decrypt a Encrypt Table from VFP ?

The Table was Encripted with ARC

And I need to Decrypt from VFP.

Thank you !!

Hugo
Cibernetica de México


Joachim Duerr (ADS) Posted on 2008-05-23 09:15:20.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Decrypt a Table from VFP !!
Newsgroups: Advantage.FoxPro
References: <48363d31@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <48367d18@solutions.advantagedatabase.com>
Date: 23 May 2008 02:15:20 -0700
X-Trace: 23 May 2008 02:15:20 -0700, 130.214.79.11
Lines: 22
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.FoxPro:255
Article PK: 1109609


Hugo wrote in <48363d31@solutions.advantagedatabase.com>:

> Somebody Can Help me ?,
> How Can I Decrypt a Encrypt Table from VFP ?
>
> The Table was Encripted with ARC
>
> And I need to Decrypt from VFP.

do you need to decrypt it or just use the encrypted tyble? How do you
access the table from VFP?

To open an encrypted table via ADO just add
EncryptionPassword=mypassword;
to the connectionstring.
remark: this works only for direct table open (adCmdTableDirect).

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


Hugo Posted on 2008-05-23 14:17:38.0Z
From: "Hugo" <gomh7172@hotmail.com>
Newsgroups: Advantage.FoxPro
References: <48363d31@solutions.advantagedatabase.com> <48367d18@solutions.advantagedatabase.com>
Subject: Re: Decrypt a Table from VFP !!
Date: Fri, 23 May 2008 09:17:38 -0500
Lines: 35
Organization: Cibernetica de Mexico
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 189.165.45.37
Message-ID: <4836d0a0@solutions.advantagedatabase.com>
X-Trace: 23 May 2008 08:11:44 -0700, 189.165.45.37
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.165.45.37
Xref: solutions.advantagedatabase.com Advantage.FoxPro:256
Article PK: 1109610

Hi Joachim,

I need to use an encrypted table via ADO, but with SQL sentences.

Thank You
Hugo
Cibernetica de México

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> escribió en el mensaje
news:48367d18@solutions.advantagedatabase.com...

> Hugo wrote in <48363d31@solutions.advantagedatabase.com>:
>
>> Somebody Can Help me ?,
>> How Can I Decrypt a Encrypt Table from VFP ?
>>
>> The Table was Encripted with ARC
>>
>> And I need to Decrypt from VFP.
>
> do you need to decrypt it or just use the encrypted tyble? How do you
> access the table from VFP?
>
> To open an encrypted table via ADO just add
> EncryptionPassword=mypassword;
> to the connectionstring.
> remark: this works only for direct table open (adCmdTableDirect).
>
> --
> Joachim Duerr
> System Consultant (Advantage Database Server)
> Sybase iAnywhere
> advantagesupport[AT]ianywhere.com
>


Lance Schmidt Posted on 2008-05-23 15:30:54.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: Advantage.FoxPro
References: <48363d31@solutions.advantagedatabase.com> <48367d18@solutions.advantagedatabase.com> <4836d0a0@solutions.advantagedatabase.com>
Subject: Re: Decrypt a Table from VFP !!
Date: Fri, 23 May 2008 09:30:54 -0600
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 10.24.38.197
Message-ID: <4836e1d0@solutions.advantagedatabase.com>
X-Trace: 23 May 2008 09:25:04 -0700, 10.24.38.197
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.197
Xref: solutions.advantagedatabase.com Advantage.FoxPro:257
Article PK: 1109611

Hi Hugo,

Then you need to create an Advantage Data Dictionary and have it manage the
password for you.

Best Regards,

Lance Schmidt
Advantage R&D

"Hugo" <gomh7172@hotmail.com> wrote in message
news:4836d0a0@solutions.advantagedatabase.com...
> Hi Joachim,
>
> I need to use an encrypted table via ADO, but with SQL sentences.
>
> Thank You
> Hugo
> Cibernetica de México
>
> "Joachim Duerr (ADS)" <jojo.duerr@gmx.de> escribió en el mensaje
> news:48367d18@solutions.advantagedatabase.com...
>> Hugo wrote in <48363d31@solutions.advantagedatabase.com>:
>>
>>> Somebody Can Help me ?,
>>> How Can I Decrypt a Encrypt Table from VFP ?
>>>
>>> The Table was Encripted with ARC
>>>
>>> And I need to Decrypt from VFP.
>>
>> do you need to decrypt it or just use the encrypted tyble? How do you
>> access the table from VFP?
>>
>> To open an encrypted table via ADO just add
>> EncryptionPassword=mypassword;
>> to the connectionstring.
>> remark: this works only for direct table open (adCmdTableDirect).
>>
>> --
>> Joachim Duerr
>> System Consultant (Advantage Database Server)
>> Sybase iAnywhere
>> advantagesupport[AT]ianywhere.com
>>
>
>
>