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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> -----Original Message-----
> From: Cheryl Sullivan [mailto:csulliva@xxxxxxx]
> Sent: Thursday, September 16, 2010 11:12 AM
> To: Tommy Pham; php-general@xxxxxxxxxxxxx
> Subject: RE:  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:tommyhp2@xxxxxxxxx]
> Sent: Thursday, September 16, 2010 11:39 AM
> To: php-general@xxxxxxxxxxxxx
> Subject: RE:  Session Vars loaded from MSSQL Query drop, those
> loaded from MYSQL Query stick
> 
> > -----Original Message-----
> > From: Cheryl Sullivan [mailto:csulliva@xxxxxxx]
> > Sent: Thursday, September 16, 2010 8:33 AM
> > To: Tommy Pham; php-general@xxxxxxxxxxxxx
> > Subject: RE:  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@xxxxxxxxx]
> > Sent: Thursday, September 16, 2010 11:00 AM
> > To: php-general@xxxxxxxxxxxxx
> > Subject: RE:  Session Vars loaded from MSSQL Query drop, those
> > loaded from MYSQL Query stick
> >
> > > -----Original Message-----
> > > From: Cheryl Sullivan [mailto:csulliva@xxxxxxx]
> > > Sent: Thursday, September 16, 2010 7:12 AM
> > > To: php-general@xxxxxxxxxxxxx
> > > Subject:  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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux