Whats the difference between 2 databases?

[Beanstine3]

What is the difference between MySQL and service-based database from Microsoft Visual Studio?

 

[USAFRet]

Visual Studio is an IDE, not a database.
But Visual Studio uses, by default, MS SQL Server. Either Express or the full package. It can, however, use just about any compliant database backend.

MySQL is just another database backend. Like Oracle, Postgres, etc, etc.

 

[Beanstine3]

Visual Studio is an IDE, not a database.
But Visual Studio uses, by default, MS SQL Server. Either Express or the full package. It can, however, use just about any compliant database backend.

MySQL is just another database backend. Like Oracle, Postgres, etc, etc.

I was meaning the "service-based" database that you can use in visual basic.

Which would be a better/easier database to use?

 

[Ijack]

There is quite a good explanation here of the difference between local and service-based database: http://techbystep.blogspot.co.uk/2009/03/how-to-connect-to-database-using-visual.html

If your application is a standalone one that will be used by only one client at a time then a local database would be best. If you have multiple clients, or are accessing data from a centralized database, then service-based is the appropriate choice.

 

[Beanstine3]

There is quite a good explanation here of the difference between local and service-based database: http://techbystep.blogspot.co.uk/2009/03/how-to-connect-to-database-using-visual.html

If your application is a standalone one that will be used by only one client at a time then a local database would be best. If you have multiple clients, or are accessing data from a centralized database, then service-based is the appropriate choice.

I am going to need a server-based databased that can be accessed by multiple users. Is MySQL a server-based database?

 

[Ijack]

MySQL is a server-based database engine and is suitable for your purposes. It's a little trickier than using the Microsoft tools, but not difficult. If you need help, there's a tutorial here: http://www.soagateway.com/tutorials/PDFs/Accessing_MySQL_from_Visual_Basic.pdf