Hi,

I have the same problem with my ERP software after migration on SQL Server
2005 64Bit. Also my software use ADO 2.8
Someone has resolve this problem?

Thanks

Daniele

"Stefano" wrote:

> Hi, our ERP software connects to SQL server 2005 Ent. 64 bit throw ADO
> 2.8.
>
> The application runs on a Windows 2003 Server with Terminal Server
> environment.... so the users work on the same server.... and a second
> server is dedicated to Sql Server.
>
> After buying a new database server running Sql Server 2005 Win
> 2003,sometimes happens tha after a period of user inactivity (about 1
> hour) , when the user restarts his activity a general network error is
> raised and ERP crashes
> It sounds like ,in the meantime,the sql server database hanged up the
> connection.
>
> This didn't happen with the old database running windows 2000 e Sql
> server 2000.
>
> Th db server has been patched to SP2 + Hot Fix, i've have also looked
> for some power safe parameter on network card,antivirus, disk
> defragmentation utility......
>
> I've also tried to install our ERP on a single PC (to avoid some
> strange combination Terminal Server & SQL...) with the same result.
>
> Any idea
>