SQL and VB

SQL and VB

• vskhyd

  im sorry man when i click on that it shows purchasing options no vbe lol
  can you maybe send me a direct link i must be blind..
  ty man
  
  

• jiwon

  *sigh* Billy, my Jukebox program is handed out on CD to users. It installs MSDE. The fact that SQL Express is installed via OneClick proves that it is installed. Have you installed SQL Express If so, check your list of services - it's in there. Check your program folders, you'll find that SQL Server exists in a seperate folder to the app, it's an application, specifically a database server, which you have installed.

  It would amaze me if it was 'heavily resourced', it would lack client tools for a start. But it IS a seperate program, a database server.

  
  
  

• Faisal Saleem

  Hi Billy. Sorry, if you want to use things like sarcasm, it doesn't travel well without emoticons :-)

  I agree - not using a database to 'save resources' makes no sense.

  How do you mean 'replace procedural arrays' You're not replacing in memory arrays with database tables across the board

  
  
  

• Jong8282

  You can't store data without a database server. Access databases use libraries that exist in windows or are easily deployed, the end result being that you can ship an MDB file and have a usable database. The new SQL Server Express uses one click, which will still install a database server on your machine, probably without any client tools ( as MSDE also did ). However, deployment methods doesn't change the fact that to use a database, you need a database program. Your code does NOT contain all the logic to store and index data, it calls code which does.

  
  
  

• Madcowrus

  you sent me a link to buy visual studio so i guess vb2005 expres doesnt have the capabilities to do this
  
  ty
  
  

• gzinger

  Hi cgraus.... I'm from the USA.... Sarcasm is a Powerful Tool in our Society and Over Here Emoticons are Usually not needed.... .... I also was being Sarcastic about 'replace Procedural Arrays...." Although I am sure it could be done with SQL...... Cheers
  

• Tom Hirst

  So I guess basically you have to decide whether you want to install sql express on the clients machine or whether you want to install ms access to the client's machine.

  But your vb.net application can either use sql or use an mdb from access.

  Visually it might be easier to use access. You can keep the mdb with your application.

  You can also backup the database from sql and then restore it from the sql on the client machine.

  Either way works out about the same except that unless you can find ms access for free, sql server express is free and the cheaper route.

  
  

• April Adams

  Your client does not need MS Access to use an MDB with your code, does it

  
  
  

• zoulasc

  Hi There mark73777....

  http://msdn.microsoft.com/vstudio/products/compare/default.aspx

  I Respectively Disagree with cgraus... You can create some really Cool SQL Express Server Applications and pass them to your friends on a CD using one click deploy..... Your friend does NOT need a Heavy Resourced SQL Server Loaded System.... Give it a Try It's a BLAST........ Cheers

  
  

• fpdeguzman78

  Hey cgraus...... I agree with everything you say......

  A Quote From Bronco Billy A couple of Posts above......

  "The link is a comparison chart... VBE is on the left.... It does All of this and more and it's Free..... Actually what cgraus said is correct but everthing is done seamlessly with click one deployment.... if your friend doesn't have netframework or Sql server express... click one will download and install it.... It's all invisable.... VBE is a Terrific Piece of Software..... Cheers" 'heavily resourced' was a sarcastric comment about the post that you locked and then unlocked where Shak recommended Access above SQL Server express and to me Actually implied or Stated that it be better to use no database to save resources..... Hell to me this is crazy.... If you don't need a database use a calculater..... The OP who sounded like he was from Midwestern USA actually bought into this BS and Opted for Access...... This is SAD..... I am so much for SQL Server Express I am replacing all my procedural Arrays with It..... Cheers

  
  

• André Monteiro

  http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx
  

• mhweiss

  The link is a comparison chart... VBE is on the left.... It does All of this and more and it's Free..... Actually what cgraus said is correct but everthing is done seamlessly with click one deployment.... if your friend doesn't have netframework or Sql server express... click one will download and install it.... It's all invisable.... VBE is a Terrific Piece of Software..... Cheers
  

• Roman S. Golubin

  thats wierd so if i publish the movie collection app the end user needs sql
  how else can you store data without the person needing a database server
  
  seems od ty anyhow
  
  

• Elizabeth Maher MS

  Yes, they need to have a database program installed ( almost certainly the same one ) and you also need to send scripts to build the actual tables/stored procs/views etc to set up a database in the server for them to connect to and use.

  
  
  
• SQL and VB