This article was previously published under Q135874
This article has been archived. It is offered "as is" and will no longer be updated.
When creating a remote view to a SQL server using TCP/IP sockets installedwith the SQL Server Client Software version 4.21a, the following occurs:
A Win32s error is displayed.
The product shuts down without any error message.
This occurs with TCP/IP sockets or IPX/SPX. It does not happen with namedpipes.
When Visual FoxPro connects to a data source and sends data, it uses a 4Kpacket size by default. This default packet size causes errors when usingTCP/IP with SQL Server and ODBC. The ODBC default is usually 512 bytes.
To work around this behavior, modify the default packet size that VisualFoxPro uses. You can achieve this by creating a connection, changing thePacketSize property of the connection, and creating the remote view againstthe connection.
The following procedure explains how to get a connection and modify itsattributes:
Open a database. To create a connection, click New and then Connection on the File menu. This opens the Connection Designer.
Set the attributes for the connection, and save it as myconnection.