I've installed Micheal Cole's DBA Toolkit and am using the fn_encrypt_aes, fn_decrypt_aes extended stored procedures. We are using SQL Server 2000, with the latest sp. We have Visual Studio 2008/ .Net 3.5 running on Windows XP
On a ASP page, which calls a function in a VB6 DLL, which calls a stored procedure, we get the value back decrypted.
On a ASPX page (C#) we call (using ADO.NET) the same stored procedure and the value comes back as a null. I have tried using DataReeaders, datatables with same results.
Running the stored procedure in query analyzer returns values.
Anybody have ideas as to why the value is null? Please help me return to sanity
Ric