DOCUMENT:Q137536  23-FEB-2000  [foxpro]
TITLE   :PRB: SQL PacketSize Property May Not Work w/Individual Handles
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:2.5,3.0
OPER/SYS:
KEYWORDS:kbvfp300 kbMDAC250

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Windows, version 3.0 
 - Microsoft Data Access Components version 2.5 
-------------------------------------------------------------------------------

SYMPTOMS
========

After you use the SQLSETPROP command to change the packet size of an ODBC
connection, the SQLGETPROP command for the packet size returns the original
value of the packet size. The expected behavior is that SQLGETPROP would return
the new packet size as set in the SQLSETPROP command.

CAUSE
=====

This behavior occurs because some drivers and servers do not support changing
the packet size on an active connection. In these situations, it is necessary to
change the default packet size prior to making each connection. This is
discussed in detail in the "Workaround" section of this article.

RESOLUTION
==========

The following workaround precludes setting up ODBC data sources connect1 and
connect2. These can be SQL, Oracle, or other ODBC connections.

Use the following commands to set individual packet sizes:

      =SQLSETPROP(0,'packetsize',8192) && 0 means default handle
      handle1=SQLCONNECT('connect1','username','password')
      paksize1=SQLGETPROP(handle1,'packetsize')

NOTE: packsize1 will return 8192

      =SQLSETPROP(0,'packetsize',4096) && 0
      handle2=SQLCONNECT('connect2','username','password')
      paksize2=SQLGETPROP(handle2,'packetsize')

NOTE: packsize2 will return 4096

STATUS
======

This behavior is by design.

MORE INFORMATION
================

The following steps illustrate the behavior of ineffective, individual packet
size settings:

Steps to Reproduce Behavior
---------------------------

      handle1=SQLCONNECT('connect1','username','password')
      =SQLSETPROP(handle1,'packetsize',8192 &&
      paksize1=SQLGETPROP(handle1,'packetsize')

NOTE: packsize1 will return 4096

      handle2=SQLCONNECT('connect2','username','password')
      =SQLSETPROP(handle2,'packetsize',8192 &&
      paksize2=SQLGETPROP(handle2,'packetsize')

NOTE: packsize2 will return 4096

Additional query words: different each separate single VFoxWin

======================================================================
Keywords          : kbvfp300 kbMDAC250 
Technology        : kbVFPsearch kbAudDeveloper kbMDACSearch kbMDAC250 kbVFP300
Version           : WINDOWS:2.5,3.0
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2000.