RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

Tommy - I ran phpinfo() but I don't see anything in it referencing MSSQL or SQLSRV. I have included all the references to "sql" I see below, but the only references I see to databases are to mySQL and SQLLite. Unfortunately I don't have any control over how service-packed the database server is. Is there something in SP 4 for SQL Server 2000 that is supposed to fix the issue I'm having, I may be able to plead my case for getting the latest SP. Is this the case, do you know? mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ Persistent cache enabled put_hits 0 put_misses 0 get_hits 0 get_misses 0 size 2000 free_items 2000 references 2 Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.cache_size 2000 2000 mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket no value no value mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Persistent cache enabled put_hits 0 put_misses 0 get_hits 0 get_misses 0 size 2000 free_items 2000 references 2 Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.cache_size 2000 2000 mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off mysqlnd mysqlnd enabled Version mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ Command buffer size 2048 Read buffer size 32768 Collecting statistics Yes Collecting memory statistics Yes PDO PDO support enabled PDO drivers mysql, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ Persistent cache enabled put_hits 0 put_misses 0 get_hits 0 get_misses 0 size 2000 free_items 2000 references 2 Directive Local Value Master Value pdo_mysql.cache_size 2000 2000 pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.6.15 -----Original Message----- From: Tommy Pham [mailto:tommyhp2@gmail.com] Sent: Thursday, September 16, 2010 11:39 AM To: php-general@lists.php.net Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick > -----Original Message----- > From: Cheryl Sullivan [mailto:csulliva@SHH.ORG] > Sent: Thursday, September 16, 2010 8:33 AM > To: Tommy Pham; php-general@lists.php.net > Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those > loaded from MYSQL Query stick > > SQL Server 8.00.818 - SP3 (Enterprise Edition) > 8? I think that's SQL 2000. If that's the case, you're 1 service pack behind. The latest service pack for SQL 2000 is 4. > Unfortunately I am fairly new to PHP and my boss just went home sick for > the day, so I don't know how to answer the question about the extension. > Can you tell me where I can find that? > phpinfo(); will give all the information pertaining to your PHP environment. Regards, Tommy > -----Original Message----- > From: Tommy Pham [mailto:tommyhp2@gmail.com] > Sent: Thursday, September 16, 2010 11:00 AM > To: php-general@lists.php.net > Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those > loaded from MYSQL Query stick > > > -----Original Message----- > > From: Cheryl Sullivan [mailto:csulliva@SHH.ORG] > > Sent: Thursday, September 16, 2010 7:12 AM > > To: php-general@lists.php.net > > Subject: [PHP] 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. > > > > What SQL Server version? What PHP extension are you using? MSSQL? > sqlsrv? > > Regards, > Tommy > > > 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 P 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. > > > -- > PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php > > > 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php