Local Or Remote

Local Or Remote

• Shril Pyrrho

  Local is on the same machine - ie. This would be you client machine that your application is running on.

  Remote is any other machine - which could be on a LAN or the another network but its not on the Client Machine.

  Examples of this would be SQL Express is designed to be deployed on the client machine and act as a local database.

  SQL Server on the other hand is designed to be deployed on another machine (ie. the server) which is on the network (although you can deploy on the same machine for development). This server is not generally the same machine as the client and can therefore be considered remote.

  
  

• TimMulholland

  IDE - Integrated development Environment

  You can use SQL 2000 in development if you happy to code directly against the database without some of the nice design tools/wizards in the IDE.

  But if your new to VB then you might want to use the IDE tools/wizards for the database development and hence you are limited with the express product to SQL Express or Access.

  
  

• DevboyX

  Thanks for clearing that up. I needed that.

  I do have SQL Server 2000 that came with my developers edition of Access, will that work

  Can Visual Basic Express deal with that older version of SQL

  I know that there will be some challenges, but I do plan on neating up my application that I made with Access and combining 2 applications into one, or are both (VBE and Access) the same caliper and I just dont realize it yet

  
  

• PeterK123

  Hello,

  Suppose there are two persons developing a ASP.net 2.0 application. How can both use same database in sql express Is there any way We have visual studio 2005 in which sql express comes inbuilt. Is there a way to share a database in that between two PCs

  Thank you

  
  

• Dave Foderick

  Great, I hope

  Whats an IDE

  Would it be better to use SQL 2000 while in developement

  Thanks for being a teacher today!

  
  

• BlueMikey

  You can use SQL Express remotely, but it will not integerate into the VB Express IDE: specifically, you won't be able to perform databinding directly (however it is possible, if you really want to use data binding).

  You can connect to any remote database with VB Express programmatically, including SQL Express. SQL Express comes with tools to enable remote connections (disabled by default). Additionally, you can modify the SQL Express setup file (settings.ini I think), to have the protocols enabled at installation.

  You can also download the SQL Server Management Studio Express to build your database, and perform mainenance tasks. http://msdn.microsoft.com/vstudio/express/sql/download/

  
  
  

• Marlon Smith

  By default it cannot - and for the solution you are talking about you really should be using a copy of SQL Server - to deploy you solution rather than SQL Server Express.

  There is a hack solution around this but as its a hack, its really not a supported scenario, although simple seaches of the VB forums will reveal the details.

  SQL Express is really a local database option whjich enables you to create SQL solutions which are directly transferrable to a full blown copy of SQL with zero or almost zero changes but it was designed to be a local solution only.

  For multi-user applications which will require remote connection from other clients then the appropriate solution would be SQL Server which supports remote connections out the box.

  Sure you can do remote scenarios using access but if you want to scale it to sql you'll end up doing much more conversion work than if you use SQL Express.

  So ultimately - the choice is up to you.

  1. Use SQL Express - hacked around to support remote connections.
  2. Use SQL Server - which supports remote connections out the box
  3. Use Access - which can support remote connections etc. but would require changes to scale it to a SQL Server

  
  

• stang4lyfe

  If I had SQL Server Express running on my machine, and I used VBE to make my application,

  Then distribute my application from within my local network then <<<

  1. Can I connect to my pc from other pcs from within my local network to share the same file that is running on my copy of SQLSE I read somewhere that the Express Edition could not achieve this.

  2. Does VBE take care of the connection If so, how does VBE connect on the other end with no mapped drive - this is a peer to peer network.

  As you can tell I'm lost! I'm wondering if I should stay with Access or not.

  
  

• flash.tato

  You can definately use SQL Server 200 with VB 2005/Express.

  The only limitation will be to do with the IDE, VB Express is intentionally limited to IDE support for VB Express and Access.

  But you can code any database you want to. So I'd probably code up using SQL express database on my development machine and eventually deploy on a SQL Server database - it can be 2000. The only things which should chnage would be you connection strings.

  So when designing you code make sure these are not hardcoded in you code. Then you can create generate a SQL Script file to rebuild the database - run it on you SQL Server 2000 to create you SQL 2000 database and you application should workk just fine.

  VB Express is so much more than Access - VB Express is a fully functioning development environment - so limitations on IDE but the compiler is exactly the same for all versions of Visual Studio 2005 - its just some of the advanced IDE stuff is limited in the express SKU's.

  
  
• Local Or Remote