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

[chersull_99]

I'm restarting this under a new subject b/c I learned some things after I initially posted and the subject heading is no longer accurate.

 

What would cause this behavior - when I populate session vars from a MYSQL query, they stick, 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 next page via redirect or form submit, the two vars loaded from MSSQL are empty. 

 

Any ideas?