The information in this article applies to:
SYMPTOMSAfter 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. CAUSEThis 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. WORKAROUND
The following workaround precludes setting up ODBC data sources connect1
and connect2. These can be SQL, Oracle, or other ODBC connections.
NOTE: packsize1 will return 8192
NOTE: packsize2 will return 4096
STATUSThis behavior is by design. MORE INFORMATIONThe following steps illustrate the behavior of ineffective, individual packet size settings: Steps to Reproduce Behavior
NOTE: packsize1 will return 4096
NOTE: packsize2 will return 4096
Additional query words: different each separate single VFoxWin
Keywords : FxinteropOdbc |
Last Reviewed: December 12, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |