Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crugerenator
Posting Yak Master
126 Posts |
 Posted - 2008-12-10 : 13:31:20
|
| I've got a table w/ an encrypted column that is being displayed to an asp page through a proc w/ a select * statement. The encrypted column will sometimes be returned properly to my asp page, and other times it will display as blank (""). This happens seemingly at random. I did realize that when the value returns as "" I can logout, log back in, and the value will populate again. Otherwise you have to wait a few minutes and it will start working again.The database is setup to use mirroring and the fail over has been tested and is working. I'm using SQL Server 2005. A trace confirms that the proc is being run by the proper login credentials each time, and there is no difference between executions of the proc that work(display the value), and executions that do not work(display "").I'm total lost here. Any ideas? Any recommendations that can point me in the right direction? |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-10 : 13:49:29
|
| it might be connection not properly closed. |
 |
|
|
crugerenator
Posting Yak Master
126 Posts |
Posted - 2008-12-10 : 16:17:23
|
| I've checked that, the record set is being closed at the end of the page. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-10 : 16:23:41
|
Do the encrypted values include a character value (ascii) that is nonprintabe in html?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-10 : 16:42:27
|
| is encrypted column an asp component or via sql server built-in encryption algorithm? |
|
|
|
crugerenator
Posting Yak Master
126 Posts |
Posted - 2008-12-10 : 17:11:10
|
| Peso - No, it doesn't contain a nonprintable character value. Hanbringl - Encryption is done with sql server built-in encryption. This is the weirdest thing. I cannot figure out why it will sometimes return null and sometimes return the correct value. I have other encrypted fields that work perfectly fine. |
|
|
|
|
|
|
Trouble w/ encrypted fields...