To connect to the database, follow these steps: For SQL Server, this could either be the user you are logged in as (Windows authentication) or a database-specific user name and password (database authentication), depending on how the database is configured. The database server can be installed on your computer or can be running on another computer.Ĭredentials for the database. In order to connect to a SQL Server or MySQL database, you need the following:Ī running instance of SQL Server 2005 or SQL Server 2008 (or the Express editions), or of MySQL versions 5 or 6. To add an existing database, you need to create a connection to the database. You can work with existing databases created in SQL Server, SQL Server Express, or MySQL. This is often required if you're using SQL Server (as opposed to SQL Server Compact) or MySQL. However, in some cases, you might want to use an existing database as part of your website. Using SQL Server Compact is convenient, because the database is deployed simply by publishing or copying the. sdf file in the App_Data folder of your website. When you create a database, it's added as an. WebMatrix includes SQL Server Compact, which is a lightweight version of Microsoft SQL Server that lets you create databases for your websites. Knowledgebase Connecting to a SQL Server or MySQL Database in WebMatrix Connecting to a SQL Server or MySQL Database in WebMatrix
0 Comments
Leave a Reply. |