> -----Original Message----- > From: Cheryl Sullivan [mailto:csull...@shh.org] > Sent: Thursday, September 16, 2010 11:12 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 > > 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? >
Here's the long lists of fixes in SP4 for SQL2000: http://support.microsoft.com/kb/888799/ http://support.microsoft.com/kb/888800/ As for if it's related to your current problem, we need to find out what are the possible causes for your problem. If you're not using mssql or sqlsrv extension, how are you able to access SQL Server, via ODBC? If you're not using ODBC either, then there is something seriously wrong with your app... or where you think you're getting the data that is supposed to be from MS SQL Server. Look at your class hitMSSQL. What does the internal of the class uses to connect, execute the query, and fetch the results? Are there any error catching/logging within the class? Or are all the statements begin with @? Regards, Tommy > 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:tommy...@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:csull...@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:tommy...@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:csull...@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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
