PRB: Exception Error When Using ODBC to SQL Server via TCP/IPLast reviewed: February 4, 1998Article ID: Q135874 |
3.00 1.30
WINDOWS
kbinterop kbprb
The information in this article applies to:
SYMPTOMSWhen creating a remote view to a SQL server using TCP/IP sockets installed with the SQL Server Client Software version 4.21a, the following occurs:
CAUSEWhen Visual FoxPro connects to a data source and sends data, it uses a 4K packet size by default. This default packet size causes errors when using TCP/IP with SQL Server and ODBC. The ODBC default is usually 512 bytes.
WORKAROUNDTo work around this behavior, modify the default packet size that Visual FoxPro uses. You can achieve this by creating a connection, changing the PacketSize property of the connection, and creating the remote view against the connection. The following procedure explains how to get a connection and modify its attributes:
STATUSMicrosoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESA TCP/IP socket is an addressable point that consists of an IP address and a TCP or UPD port number. It provides applications access to TCP/IP protocols. A Named pipe is a communication API that provides a software connection between a client and a server. For more information about using TCP/IP named piped versus sockets, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q128985 TITLE : Comparing SNA Client TCP/IP Named Piped vs Sockets |
Additional reference words: 3.00 VFoxWin TCPIP
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |