Hello Everyone,

For a simple project I needed to create an ActiveX DLL to open a Visual Foxpro database (DBF). This all went fine, and the initial tests (in another VB project) where succesfull. However, when I try to use the DLL in IIS (IIS5 on W2K Sp2), I recieve the following error:

MicrosoftRDO.RdoConnection error '800a9c42'

S1110: [Microsoft][ODBC Driver Manager] Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled 

IMHO this is a very typical MS error: Do I need to add the "SQL_DRIVER_NOPROMPT", or remove it? Do I need to enable Connection Pooling or disable it? I've tried all kinds of things, but none seem to work. There is also very little to be found about "Connection Pooling". The (partial) source code from my DLL:

cn.Connect = "SourceType=DBF;SourceDB=n:\fxp;Driver={Microsoft Visual FoxPro Driver}"
   cn.CursorDriver = rdUseOdbc
   cn.EstablishConnection "SQL_DRIVER_NOPROMPT"

There is no need to post more, since the error occures on the cn.EstablishConnection line. I added the "SQL_DRIVER_NOPROMPT" myself, but it doesn't seem to have any effect if there's anything else there.

Does anyone how to solve (or only create a workaround for) this problem?

Any help is appreciated,
Jelmer Baas