we have a sql server personal edition installed on a Windows XP Professional machine (which is not part of a domain), so SQL server authentication is used. Our software application connects to the database (through ADO with udl file) to retrieve information. What happens is that the application connects correctly to the database and the user can do his work, but at some point (different every time) the application loses it's connection.
Does someone know what's causing this? Perhaps the lack of a domain, or maybe the ADO drivers?
The error message is: '[DBNETLIB][ConnectionOpen (Connect()).] The SQL Server does not exist or the connection is refused. MDAC version is 2.70. About network libraries, default settings from the installation were left unchanged.