>IIS and ASP use connection pooling for database connections in order to conserve resources. We're not getting anywhere with this, are we! Can you email me the source code for your DLL, or, if it's short enough, post it here? Maybe if I look at it I can figure something out.
>
SOURCE CODE
DEFINE CLASS SubMain AS Custom OLEPUBLIC
PROCEDURE TransferToSQL
gnCH=SQLSTRINGCONNECT('DSN=MyDSN;UID=MyUser;PWD=MyPassWord;DATABASE=DatabaseDB')
IF gnCH < 0
lcMessage = MESSAGE()
RETURN lcMessage
ELSE
...
ENDIF
ENDPROC
ENDDEFINE

Thanks
Nick,


>>SQL Server use Standard security.
>>Also, other ASP pages create a ADO connection to SQL with no problem.
>>
>>What is the pooling connection in the error message?