We are using VB4.0 32-bit to access a SQL Server database running on NT
Server 3.51 using IPX/SPX as the Net-Library. As long as we use the
OpenRecordset method with SQL Passthrough, the server maintains the current
connection. However, if we use the Execute method with SQL Passthrough the
server creates a new connection, executes the SQL statement, and then
disconnects the connection. This process slows the app down considerably.
If we don't use SQL Passthrough with it, the server maintains the current
Any ideas on how we can prevent the new connection using Execute? If not,
are there any issues with not using SQL Passthrough (speed, etc.)?