09-04-2000, 08:03 AM
whenever i tried to use ODBC to connect to SQL Server 7 using MTS, this error arise, it said, "SQL_DRIVER_NOPROMPT is not set when connection pooling is enabled". How to set it when i'm using DataEnvironment and ADODB Recordset in VB6? All the documentation and HelpFile only gives solution on C++ environment. Please write down the sample codes if possible. Any other option to overcome this problem is welcome as well.