locked
VB 2005 and SQL Server Express RRS feed

  • Question

  • Hi

    I'm new to using 2005, both VB and SQL Server Express.  I'm trying to create a program which talks to a database on a server for my friends business (big favour!).  His company has about 7 people that work there and each of them will have a copy of the VB app installed which will interface with the database.

    Personally i have quite a bit of experience with standalone VB apps, but i've never really approached anything of this size before, but I'm trying doing this as a) a favour to my friend and b) to learn VB and Sequel a little better as i'm looking to change my job in a few months time.

    There are no full time IT staff there, any backups will need to be either done automatically or by an office administrator with limited IT skills. 

    I'm not sure how true this is, and i've had no luck proving o#r disproving it by searching the web.  But I heard a rumour that VB 2005 can create and access a 'file' SQL Server 2005 database, which consists of some files, with no installed software or running services.  Could somebody please clarify whether this is correct or not?

    Also I would be very grateful if anybody could make any recommendations upon how they think I should setup the database, with regards to 'file' or running, or backup options etc.  Well really any comments at all would be very helpful.

    Thanks for reading this.

    Jamie.

    Sunday, November 19, 2006 3:52 PM

Answers

  • The rumors you are hearing about files instead of databases are probably due to the new User Instance feature in SQL Express. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp This actually does require SQL Express to be installed.  This also will not work for your application because it doesn’t support remote connections.  You will need to use SQL Express to create a normal server database.  This is done by creating a connection rather than creating a database in the VB IDE.

    Tuesday, November 21, 2006 12:51 AM

All replies

  • The rumors you are hearing about files instead of databases are probably due to the new User Instance feature in SQL Express. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp This actually does require SQL Express to be installed.  This also will not work for your application because it doesn’t support remote connections.  You will need to use SQL Express to create a normal server database.  This is done by creating a connection rather than creating a database in the VB IDE.

    Tuesday, November 21, 2006 12:51 AM
  • Thank you.
    Tuesday, November 21, 2006 11:28 AM