sql 2005 connection problem

• dinudisha

  Newbie

  Points: 7

  More actions

  April 15, 2010 at 2:36 am

  #140381

  hello friends ..

  i have an application developed in visual basic. till now i was using sql2000 there was not problem , now i want to connect the same application with sql2005 , initailly i got the error invalid connection string problem. But i managed to generate now the error is different i.e

  " named pipes provider: could not open connection to sql server [1231]"

  i am using laptop with os as xp .

  please any one solved this ??

• seth delconte

  SSCertifiable

  Points: 6388

  More actions

  April 15, 2010 at 8:37 am

  #1152166

  Are you using SQL Server 2005 Express Edition? If so, your connection string probably needs '\SQLEXPRESS' added to the server name.

  _________________________________
  seth delconte
  http://sqlkeys.com