Disable connection pooling using sqloledb
This Microsoft OLE DB Provider for SQL Server connection string can be used for connections to SQL Server 2000 and SQL Server 7.0.
This one is usefull when receving errors "sp_setapprole was not invoked correctly." (7.0) or "General network error. Check your network documentation" (2000) when connecting using an application role enabled connection. Application pooling (or OLE DB resource pooling) is on by default. Disabling it can help on this error.
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;
User ID=myUsername;Password=myPassword;OLE DB Services=-2;