Hi Andy,

Well I've done a bit more research (bought David Sceppa's book Programming ADO) and the problem seems to be the connection objects cursor location - it defaults to Server...

Hi Andy,

I had already done this with NetIQ but now I know about sysprocesses I repeated the test and it did reveal something I hadn't noticed before. Connections are created...

Hi Andy,

As I said I'm new to SQL Server so no I hadn't check sysprocesses but I have now. All I can report that my test program creates 5 new...

Hi Andy,

Thanks for taking the time with this. Following is code snippit that demonstrates the problem and shows how I'm access the database. My environment is:

Visual...