problem running vb.net application with sqlexpress in system with only .NET FRAMEWORK

problem running vb.net application with sqlexpress in system with only .NET FRAMEWORK

• jqq

  SQL Server Express is a backend database although the GUI tools are more lightweight than the ones of the more bigger editions. If you want to use user instances as mentioned in the connection string, you will need to have a SQL Server Express Service in place to attach the database to the Service. SQL Server Express can be deployed within your application (even through clickonce deplyoment but at the end need to be installed).
  
  HTH, Jens K. Suessmeyer.
  
  ---
  http://www.sqlserver0205.de
  ---
  

• Deerhake44

  What's your OS If WIndows XP Pro, this needs SP2 and updated security patches
  
  

• Rick Thomas

  Manyam wrote:

  I dont want to use any backend database. I only want to use the database that comes with .net (i.e sqlexpress) Please help me how can i get through this problem.

  SQL Express is not part of the .NET Framework, it is a completely separate product that must be installed if you are going to use it. You can add SQL Express as a prerequisite to you application installation automatically using either ClickOnce or standard Setup Projects in VS 2005, in your projects properties, click the Prerequisite button and make sure SQL Express is checked in the list. This will automatically include the SQL Express installer in your deployment and install it on the target computer if it is needed.

  Mike

  
  
  

• Benedikt

  hi,

  Manyam wrote:

  When i am trying to install this application in the standalone system with .net framework 2.0 and no backend database it giving the following error provider: sql network interfaces, error 26 - Error locating Server/ Instance Specified

  I can't understand if you installed SQLExpress as well, on the target computer... did you

  regards

  
  
  

• modtran

  Hi,

  Thanks for your valueable suggestion. So i cannot run a vb application developed using sql server management studio without SQL EXPRESS.I tried installing SQL EXPRESS in standalone system, but its giving issues.

  Process followed -->

  Uninstalled existing framework.

  Installed .NET framework 2.0Dowloaded SQLEXPRESS and istalled in system.

  Its throwing a error that .net should require some updates... What updates do we need to install to get this working.

  Thanks in advance.

  
  
  

• JohnTMSDN

  Hi,

  Thanks for your suggestion. So we cannot run vb.net application that is developed using sql server management studio without SQL EXPRESS and only .net framework.

  I tried to open the link provided by you. Its not opening. I am getting page cannot be displayed.

  
  
  
• problem running vb.net application with sqlexpress in system with only .NET FRAMEWORK