Encrypted key fall

kydraxa

The database stores the encrypted table, the work that is carried out by means of certificates and encryption keys. An employee who works with them in the Navision have a certificate with a password.
For security reasons there are two connection from one Navision. One from Navision himself, and other from SQL connection string to the server with odbc, that run from cal code:
Provider = SQLOLEDB.1; Integrated Security = SSPI; Data Source = server name; Initial Catalog = db; Connection Timeout = 240; Application Name = NavKey;
Keys opened with:
OPEN SYMMETRIC KEY key DECRYPTION by CERTIFICATE cert with password = password;
it uses nested key until the third level.
With public key available to any type of encrypted data in the tables of the view to insert and remove through the application. When private keys is null application server returns the data that does not appear in the form of an employee and therefore can not work with them (did not see any corny lines). Level access management studio closed.
And here's the most problem.
With such use application + sql server 2005 all runs smoothly.
With such use application + sql server 2008/2012 encryption keys "fall off."
That is, the server closes them without a team to close them. When it usually closes the main key (the key of the top level).
Connoisseurs server and encryption seek your advice and help on this issue keys. I'll be glad to any advice and idea of how to solve this problem, he has the whole head itself it broke ...
Please excuse the rough language, if that is not clear to explain in detail every question. Thank you.
Maybe problem in Microsoft ActiveX Data Objects 2.8 Library that doesn’t work correct with sql 2008 or 2012.