Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227

    Unanswered: lost connection with personal edition

    Hi,

    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?

    Thanks
    Johan

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Whats the error message during the process?
    How about the default netlib used.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    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.
    Johan

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Define server alias using client network utility and use TCP/IP as default netlib.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •