Wednesday, December 17, 2008

Encrypted Free Tables and Visual Studio

I discussed working with encrypted free tables in my November FAQ, however, the topic deserves a bit more detail. The best way to work with encrypted tables with any of the Advantage supported development environments is to use a data dictionary. However, this is not always possible or even desirable.

To use encrypted tables with the Advantage .NET data provider you must specify the encryption password in the connection string and open the table using a TableDirect command type. To open an encrypted table using SQL with the Advantage .NET data provider you must use a database connection. The following code snippet demonstrates opening an encrypted free table.

   1: AdsConnection cn;
   2: AdsCommand cmd;
   3: AdsDataAdapter da;
   4: DataSet ds;
   6: string sConnect = "Data Source=C:\\Data";
   7: sConnect += ";ServerType=Remote";
   8: sConnect += ";EncryptionPassword=password";
  10: cn = new AdsConnection(sConnect);
  11: cmd = cn.CreateCommand();
  12: cmd.CommandType = CommandType.TableDirect;
  13: cmd.CommandText = "Customer";
  15: cn.Open();
  17: da = new AdsDataAdapter(cmd);
  18: ds = new DataSet();
  20: da.Fill (ds);

You can encrypt and decrypt tables using an Advantage Extended Data Reader which has EncryptTable and DecryptTable methods. To use the extended data reader you must use a CommandType of TableDirect and the ExectueExtendedReader method. To use EncryptTable and DecryptTable you must open the table exclusively by setting the Shared connection string keyword to False.

There is an example application available on the Advantage DevZone which demonstrates these methods. It is listed in Code Central under C#/VB.NET and is called Free Table Encryption Demo. It is a Visual Studio 2005 project which contains C# and VB.NET code.


for IT the said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru Dot Net Training in Chennai. Nowadays Dot Net has tons of job opportunities on various vertical industry.
or Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.

sakthi said...

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
rpa training in bangalore
best rpa training in bangalore
RPA training in bangalore
rpa course in bangalore
rpa training in chennai
rpa online training

Inigo joseph said...

Really great post, I simply unearthed your site and needed to say that I have truly appreciated perusing your blog entries. I want to say thanks for great sharing.
python Course in Pune
python Course institute in Chennai
python Training institute in Bangalore

jeeva said...

All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
microsoft azure training in bangalore
rpa training in bangalore
best rpa training in bangalore
rpa online training

ragini ragini said...

I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.
AWS Training in pune
AWS Online Training

Priyanka said...

Attend The Python training in bangalore From ExcelR. Practical Python training in bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python training in bangalore.
python training in bangalore

ajish said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
Python Training in Electronic City

Python Training In Pune said...

I feel very grateful that I read this. It is very helpful and very informative and I Python training in pune really learned a lot from it.

Madhu Balan said...

Great post and informative was awesome to read, thanks for sharing this great content to my vision.
Good discussion.
Java Training in Chennai
Java Training in Coimbatore
Java Training in Bangalore

Riya Raj said...

Great blog!!! The information was more useful for us... Thanks for sharing with us...
Python Training in Chennai
Python course in Chennai
Python Classes in Chennai
Best Python Training in Chennai
Python Training in Annanagar
Python training in vadapalani
Digital Marketing Course in Chennai
Hadoop Training in Chennai
Big data training in chennai
JAVA Training in Chennai

Unknown said...
This comment has been removed by the author.
charmidevan said...

nice article and its very informative...Thanks for sharing...
Mobile Testing Training in Chennai
Mobile Testing Training
Mobile Application Testing Training
Mobile Testing Training in Velachery
Mobile Testing Training in Tambaram
Manual Testing Training in Chennai
LoadRunner Training in Chennai
Photoshop Classes in Chennai
Spring Training in Chennai
QTP Training in Chennai

gowsika said...

Nice article,i really admire after reading this blog....
Best Aviation Academy in Chennai
Air Hostess Academy in Chennai
Airline Courses in Chennai
Ground Staff Training in Chennai
Airport Management Courses in Bangalore
Airport Management Courses in Chennai
Air Hostess Academy in Chennai
Air Hostess Course in Mumbai
Ground staff training in Bangalore
Best Aviation Academy in Chennai

shwethapriya said...

Very informative blog. Got more information about this technology.
Node JS Training in Chennai
Node JS Training Institute in chennai
German Classes in Chennai
pearson vue exam centers in chennai
Informatica MDM Training in Chennai
Hadoop Admin Training in Chennai
Node JS Training in Tnagar
Node JS Training in Velachery

lokeshivam said...

I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision.keep blogging.
Data Science Course in Chennai
Data Science Certification in Chennai
Data Science Training Institute in Chennai
R Training in Chennai
RPA Training in Chennai
DevOps certification in Chennai
Data Science course in Velachery
Data Science course in Tambaram
Data Science Training in Porur

Sivanandhana Girish said...

Your blog is nice. I believe this will surely help readers who are really in need of this vital piece of information. Thanks for sharing and kindly keep updating.
Spoken English Classes in Chennai
Best Spoken English Classes in Chennai
IELTS Coaching in Chennai
IELTS Coaching Centre in Chennai
English Speaking Classes in Mumbai
English Speaking Course in Mumbai
IELTS Classes in Mumbai
IELTS Coaching in Mumbai
IELTS Coaching in Anna Nagar
Spoken English Class in Anna Nagar

Sadhana Rathore said...

Fabulous post admin, it was too good and helpful. Waiting for more updates.
Tally course in Chennai
Tally Training in Chennai
Tally institute in Chennai
AngularJS course in Chennai
ccna Training in Chennai
PHP course in Chennai
Salesforce course in Chennai
Tally Course in Velachery
Tally Course in Anna Nagar
Tally Course in T Nagar

kishore said...

Great blog...! This blog contains useful information about this topic. Thank you for sharing this blog and can you do more updates & sharing like from this blog.
Excel Training in Chennai
Excel Course in Chennai
Tableau Training in Chennai
Linux Training in Chennai
Oracle Training in Chennai
Job Openings in Chennai
Oracle DBA Training in Chennai
Pega Training in Chennai
corporate training in chennai
Power BI Training in Chennai
Excel Training in Tambaram

Reshma said...

Excellent post! It is really informative to all.keep update more information about this.
AngularJS Training in Velachery
AngularJS Training in Tambaram
AngularJS Training in OMR
AngularJS Training in T nagar
AngularJS Training in Thiruvanmiyur
AngularJS Training in Adyar
AngularJS Training in Porur
AngularJS Training in Vadapalani
AngularJS Training in Anna Nagar

manjuragul said...

It's a looks very awesome article! Thanks a lot of sharing for information.
Python training in chennai
Python course in chennai
Python training in Anna Nagar
AWS course in chennai
Data science training in chennai
RPA course in chennai
Hadoop training in chennai
IELTS coaching in chennai

shivam said...

Flying Shift - Packers & Movers in Bhopal

vinudevan said...

Valuable one...thanks for sharing...
DOT NET Training in Chennai
dot net course
Dot net training
dot net classes
dot net training in Thiruvanmiyur
Html5 Training in Chennai
Spring Training in Chennai
Struts Training in Chennai
Wordpress Training in Chennai
SAS Training in Chennai