Hi

I found a possible solution:

ADO SQL is providing two relevant properties for defining a Time-Out in Visual Basic:

#1 CommandTimeOut

#2 ConnectionTimeOut

The last property indicates how long to wait while establishing a connection before terminating the attempt and generating an error.

Reference:

In my case, it was set to 15 seconds-what was too short for my query.

Increasing this value to 5 minutes, it is working fine for me.

The question that stays in the room is still why a server suited with 8 core CPU working slower than 15 yrs old server before.

Stephan