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;
   5:  
   6: string sConnect = "Data Source=C:\\Data";
   7: sConnect += ";ServerType=Remote";
   8: sConnect += ";EncryptionPassword=password";
   9:  
  10: cn = new AdsConnection(sConnect);
  11: cmd = cn.CreateCommand();
  12: cmd.CommandType = CommandType.TableDirect;
  13: cmd.CommandText = "Customer";
  14:  
  15: cn.Open();
  16:  
  17: da = new AdsDataAdapter(cmd);
  18: ds = new DataSet();
  19:  
  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.

55 comments:

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

Unknown 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

charmidevan said...
This comment has been removed by the author.
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

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

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

sasi 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

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

Karuna said...

Nice blog thanks for sharing Is this a special day for you? Beautiful and fragrant flowers are sure to make it even more amazing of a day no doubt. This is why Karuna Nursery Gardens offers you the best rental plants in Chennai that too at drop dead prices.
plant nursery in chennai
rental plants in chennai
corporate gardening service in chennai

Bernot said...

Good post... Digital marketing is far more better than traditional marketing. It has a great potential which leads to develop your business in a short period.
best digital marketing company in chennai, SEO company in chennai, digital Marketing Agency in Chennai

akshaya said...

This blog seems to be the best guide for its readers, where it guides them with accuracy and I believe blindly that this blog would only give its best. Web Designing Course Training in Chennai | Web Designing Course Training in annanagar | Web Designing Course Training in omr | Web Designing Course Training in porur | Web Designing Course Training in tambaram | Web Designing Course Training in velachery

Anonymous said...

I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
app and you are doing well.


Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery

Data Science Institute In Banglore said...
This comment has been removed by the author.
Data Science Institute In Banglore said...
This comment has been removed by the author.
DataScience Specialist said...

Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work.
Data Science Course in Bangalore

DataScience Specialist said...

it was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity..
Data Science Training in Bangalore

Damien Grant said...

http://digitalweekday.com/
http://digitalweekday.com/
http://digitalweekday.com/
http://digitalweekday.com/
http://digitalweekday.com/
http://digitalweekday.com/
http://digitalweekday.com/
http://digitalweekday.com/

sudhan said...

It was very usefull and wonderful session which helped to gain more knowledge.
Robotic Process Automation (RPA) Training in Chennai | Robotic Process Automation (RPA) Training in anna nagar | Robotic Process Automation (RPA) Training in omr | Robotic Process Automation (RPA) Training in porur | Robotic Process Automation (RPA) Training in tambaram | Robotic Process Automation (RPA) Training in velachery

radhika said...

It was very usefull and wonderful session which helped to gain more knowledge.

AWS training in Chennai

AWS Online Training in Chennai

AWS training in Bangalore

AWS training in Hyderabad

AWS training in Coimbatore

AWS training

Data Science Institute In Banglore said...

Really nice and intriguing post. I was trying to find this sort of advice and appreciated reading this one. Keep posting. Thank you for sharing.

Data Science Training Institute in Bangalore

Best Data Science Courses In Bangalore said...

Very wonderful article. I liked reading your article. Very wonderful share. Thanks ! .
Best Data Science Courses In Bangalore

Data Science Hyderabad said...

Great post, found very informative thank you keep up the good work.
Data Science Course in Hyderabad 360DigiTMG

Ethical Hacking Course said...

Awesome blog with interesting topic and information provided was very valuable waiting for next blog update thank you .
Ethical Hacking Course in Bangalore

Data Science Training said...

Really nice and interesting blog information shared was valuable and enjoyed reading this one. Keep posting. Thanks for sharing.
Data Science Training in Hyderabad

Devi said...

Nice blog, From this blog I learned more specific information,
Thanks for sharing this blog.
artificial intelligence advantages
what is net core
introduction to bigdata and hadoop
top devops tools
selenium interview questions and answers

Farhan.Jee said...

Python has been created with the newcomer in mind. Completion of basic tasks requires less code in Python, compared to other languages. data science course in india

Pathway for German Language said...
This comment has been removed by the author.
Sharnith said...

Really great...! I appriciated for your best post and Good job...
Content Course in Chennai
Online Content Writing Course
Google Analytics Online Course
Google Analytics Training in Chennai

Hemapriya said...

Awesome article! You are providing us very valid information. This is worth reading. Keep sharing more such articles.
Data Science Course in Chennai
Data Science Courses in Bangalore
Data Science Online Course
Data Science Course in Coimbatore
Data Science Course in Hyderabad

vé máy bay từ hàn quốc về Việt Nam said...

Liên hệ mua vé rẻ tại đại lý Aivivu, tham khảo

mua ve may bay di my

vé máy bay từ mỹ về việt nam giá rẻ

vé máy bay từ sài gòn ra đà nẵng

vé máy bay đi đà lạt vietjet

gia ve may bay ha noi phu quoc

Data Science Institute Bangalore said...

It fully emerged to crown Singapore's southern shores and has undoubtedly put it on the world residential monument map. Still, I scored more points than I have in one season for GS. I think it would be hard to find someone with the same consistency that I have had over the years, so I'm happy.
Data Science Institute in Bangalore

Data Science in Pune said...

Actually I read it yesterday but I had some ideas about it and today I wanted to read it again because it is so well written.
Data Science Course in Pune

Data Analytics Course in Bangalore said...

I really enjoy reading all of your blogs. I just wanted to let you know that you have people like me who appreciate your work. Definitely a great article. Congratulations! The information you have provided is very helpful.
Data Analytics Course in Bangalore

Career Programs Excellence said...

I really enjoy reading all of your blogs. I just wanted to let you know that you have people like me who appreciate your work. Definitely a great article. Congratulations! The information you have provided is very helpful.
Digital Marketing Course in Bangalore

Best Data Science Courses in Bangalore said...

I really enjoy reading all of your blogs. I just wanted to let you know that you have people like me who appreciate your work. Definitely a great article. Congratulations! The information you have provided is very helpful.
Best Data Science Courses in Bangalore

360DigiTMG-Pune said...

Incredibly conventional blog and articles. I am realy very happy to visit your blog. Directly I am found which I truly need. Thankful to you and keeping it together for your new post.
best data science course in pune

Akshay said...

I stumbled across your blog and wanted to say that I really enjoyed reading your articles. Anyway, I will subscribe to your feed and hope you post again soon.
Data Scientist Course in India

Tamil novels said...

Thank you for sharing this valuable information with us.
Tamil romantic novels pdf
Ramanichandran novels PDF
srikala novels PDF
Mallika manivannan novels PDF
muthulakshmi raghavan novels PDF
Infaa Alocious Novels PDF
N Seethalakshmi Novels PDF
Sashi Murali Tamil Novels PDF

Reshma said...

Great post. Thanks for sharing such a worthy information.....
Empower your Skills with Ethical Hacking Training
Skills Needed for an Ethical Hacker

Techwriter said...

I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end.
Python Training In Pune

Vlad said...

Very inspiring and helpful. Thank you so much for sharing this great blog.

Hussey said...

Happy to read the informative blog. Thanks for sharing
best java training institute in chennai
best java training institute in chennai

Reshma said...

Thanks for sharing such an amazing blog! Kindly update more information
Five Reasons to Use Google Ads
5 Reasons to Use Google Ads

Matt Reeves said...

This post is so interactive and informative.keep update more information...
Salesforce Training in Tambaram
Salesforce Training in Anna Nagar

werwer said...

Easeus Data Recovery Wizard Crack is a biggest 100 % free data recovery application. By utilizing this one can recuperate structured, removed and as well as dropped answers. You’re able to recuperate it as a result of a laptop or Personal

Anonymous said...

composing ace break rendition full download is quick to improve your composing abilities. It is a straightforward and simple to-utilize arrangement with graphical measurements that shows you precisely what amount of progress you can make on maps; Typewriter the executives programming can be utilized by clients and various clients at the same time with their superior printing abilities. typing Master Pro 11 Crack

Cyberz Pc said...

Much obliged as a results a reasonable setup as you have been endorsed to share direction thinking us. we can totally praise through and through you have completed here because of the reality you have made my comport your self as pleasantly ventilated as ABC. Crack Hotspot Shield

Links For You said...

You understand your tasks stand apart of the group. there might be something exceptional nearly them. It appears to me every one of them are in truth remarkable! FileviewPro Key

Unknown said...

https://www.weestreem.com/project/conference-community-living-ontario

Maya said...

Nice message, I read this blog all the time, and it always made me happy.
mIRC

hibapc said...

DVDFab Crack
DVDFab Crack is great software is very potent programmer which is incredibly simple and save, duplicate, manufacture, and access protected DVDs.

Anonymous said...

Property management companies in St. Louis are essential for efficient rental property operations. From tenant screening to rent collection, these companies handle it all. If you're a landlord seeking professional assistance, consider hiring one of the reputable property management companies in St. Louis. They have extensive knowledge of local regulations and can effectively market your properties. With their expertise, you can enjoy stress-free property ownership while maximizing your rental income. Whether you own residential or commercial properties, partnering with property management companies St. Louis is a wise investment for long-term success.

Anonymous said...

When considering reliable security solutions in the bustling metropolis, one cannot overlook the expertise offered by the NYC Security Company. Their unparalleled commitment to safeguarding businesses and residences sets them apart from the competition. With a diverse range of services, including surveillance systems, access control, and on-site guards, NYC Security Company ensures comprehensive protection tailored to individual needs. Their highly trained professionals prioritize customer satisfaction, employing state-of-the-art technology to mitigate risks effectively. Partnering with NYC Security Company guarantees peace of mind, knowing that your safety is in capable hands. Stay ahead of potential threats with the trusted expertise of this leading security firm.

Ahsanullah khan said...

Nice Job
Windows KMS Activator Ultimate Crack
Windows Loader