Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

Hi there – I’m new to this news group. Any help with this is appreciated – When I populate session vars from a MYSQL query, they are still there when I change pages. If I populate them from an MSSQL query, they drop. It doesn't matter if I get to the next page using a header redirect or a form submit. I have two session vars I'm loading from a MYSQL query and they remain, the two loaded from MSSQL disappear. I have confirmed that all four session vars are loading ok initially and I can echo them out to the page, but when the application moves to the next page via redirect or form submit, the two vars loaded from MSSQL are empty. Any ideas? Cheryl L. Sullivan Interface Analyst / Web Developer Sacred Heart Hospital (www.shh.org) 421 Chew Street • Allentown, PA 18102 Office: 610-776-4784 • Cell: 484-544-2416  Please consider the environment before printing this e-mail Notice: This communication, including attachments, may contain information that is confidential and protected. It constitutes non-public information intended to be conveyed only to the designated recipient(s). If you believe that you have received this communication in error, please notify the sender immediately by return e-mail and promptly delete this e-mail, including attachments without reading or saving them in any manner. The unauthorized use, dissemination, distribution, or reproduction of this e-mail, including attachments, is prohibited and may be unlawful. Thank you.