Database Encryption

Thread is closed for posting
5 posts, 0 answers
  1. devoas
    devoas avatar
    71 posts
    Member since:
    Dec 2009

    Posted 28 Feb 2010 Link to this post

    hello,

    We are trying to use Database Encryption Tool:  DBDefence for SQL Server 2008 (http://www.dbdefence.com/), once any Database is Encrypted it requires to have following kind of SQL statement to be executed.

    OPEN SYMMETRIC KEY DBDX DECRYPTION BY PASSWORD = ‘...’ 

    this will enable Database access for particular Connection, 

    Kindly advise how we can use this with Open Access, I tried to run this after NewObjectScope by scope.GetSqlQuery(script)
     and also by  ExecuteDDLScript  but it did't worked.. Access is not granted, seem that I need call this anywhere else. Please advise.

    Thanks 
    devoas


  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 03 Mar 2010 Link to this post

    Hello devoas,

    You can try to setting this statement to the "Connection init SQL" option in the Backend configuration settings dialog. The dialog can be found under the Telerik -> OpenAccess -> Configuration menu.
    Hope that helps.

    Regards,
    Damyan Bogoev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. devoas
    devoas avatar
    71 posts
    Member since:
    Dec 2009

    Posted 09 Mar 2010 Link to this post

    Dear Damyan,

    Thanks for you reply. Unfortunately this did not worked.  I put the decryption code in initSql thru Backend configuration setting dialog but I cannot even use the database in reverse mapping.  Infact  I cannot see/verify that the commands written in initSql is working or not as If I write some incorrect code in it, still it is not giving any error .....   How can I see if the statements written with initSql are running or not.

    Thanks 
    devoas


    Thanks 
    devoas,

  4. devoas
    devoas avatar
    71 posts
    Member since:
    Dec 2009

    Posted 09 Mar 2010 Link to this post

    Dear Damyan,

    Thanks for you reply. Unfortunately this did not worked.  I put the decryption code in initSql thru Backend configuration setting dialog but I cannot even use the database in reverse mapping.  Infact  I cannot see/verify that the commands written in initSql is working or not as If I write some incorrect code in it, still it is not giving any error .....   How can I see if the statements written with initSql are running or not.

    Thanks
    devoas
  5. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 12 Mar 2010 Link to this post

    Hi devoas,

    You could the logging mechanism of the Telerik OpenAccess ORM in order to see whether the statements written inside the initSql are running. You could set the logging from the Telerik | OpenAccess | Configuration | Backend Configuration Settings dialog under the Logging node.
    Please set the Event Tracing option to True as well as the Log level to all. You should specify how the events should be logged in a text file or displayed in a console window.
    Hope that helps.

    All the best,
    Damyan Bogoev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top