Multiple Data Files (SQL Express) can be used in one application ?

Multiple Data Files (SQL Express) can be used in one application ?

• Falconetti

  Dear ShoagMSFT,
  
  Is it means that if there is three (or more) SQL Server Express files on remote computer and I can not open all of them simultaniously (Which I want)
  
  Thanks
  
  Parminder Singh Dhillon

  
  

• snegidhan

  This is a limitation of Visual Basic Express. SQL Server Express is similar to the old MSDE - it has certain limitations compared to the full version of SQL Server 2005. See http://msdn.microsoft.com/vstudio/express/sql/ for more information.
  
  As mentioned earlier, Visual Basic Express only supports local data. You can use more than one MS Access data file in your application only if those data files are installed on the same computer as your application.  
  
  If you are currently doing professional client-server development using Visual Studio .NET 2002, the Express Editions are not intended for you. For professional development you will need the full version of Visual Studio 2005, which has many improvements over Visual Studio .NET 2002. Of course, the decision to upgrade (or not) is entirely up to you. 
  
  Steve Hoag
  
  

• Brent Hunt

  Hi There

  Hey Steve

  Are you saying VB Express will Not Generate a Client Server Application on a local Network Say one Server and 3 clients...... IE. The SQL Express Server Database On one Computer and the other 3 Client computers using VB Express Apps cannot access the SQL Express Server Computer
  
  Cheers
  Bronco Billy
  "Beer and Fast Women are Ok... No Cigarettes or Hard Liquor Allowed
  

  
  

• Lau_R

  Yes, you can use multiple SQL Express database files from a single application. The only limitation with the Express edition is that you can only access databases on your local machine; Visual Studio .NET 2002 allowed you to access remote databases.
  
  Hope this helps,
  Steve Hoag
  Visual Basic Express
  
  

• Brog

  shoagMSFT wrote:

  Yes - the Express Edition is not intended to create client-server applications; for that you would need the full version. The aim of Visual Basic Express is to provide a tool for beginning programmers to learn programming and for "hobbyists" that want to create apps for themselves and their friends. For this reason the data story is limited to local data - that is, a database on the same computer as the application. - Steve

  
  
  Is this limitiation for Visual Basic .net Express 2005 or SQL Server Express 2005
  
  Can I use more then one MS Access data files from other computers in my application using Visual Basic Express 2005
  
  I have licenced copy of VB .net 2002, then If not why I should go for Express
  
  Thanks
  
  Parminder Singh Dhillon
  
  

• iveys

  Parminder -
  
  To clarify - you can only open SQL Server databases on the computer where your application is running. You cannot open databases over a network; this is a limitation of the Express edition.
  
  If you have three (or more) databases installed on the local computer, you can access all of them simultaneously from your application.
  
  Steve Hoag
  
  

• Ronald Huereca

  Yes - the Express Edition is not intended to create client-server applications; for that you would need the full version. The aim of Visual Basic Express is to provide a tool for beginning programmers to learn programming and for "hobbyists" that want to create apps for themselves and their friends. For this reason the data story is limited to local data - that is, a database on the same computer as the application.
  
  That said, I have seen other posts on this forum suggesting that the limitation is simply at design time - once an application created with Express is deployed you could connect to a remote database by changing the connection string. I haven't tried this and don't know the details, but you might check it out.
  
  - Steve
  
  
• Multiple Data Files (SQL Express) can be used in one application ?