How do I connect to a SQL Server database using WebMatrix?

sql-server webmatrix
Larsenal picture Larsenal · Sep 17, 2010 · Viewed 13.5k times · Source

I added a connection and it shows up in "Other Connections" but I can't seem to reference it.

var db = Database.Open("MyNewConnection");

throws an exception: Connection string 'MyNewConnection' was not found.

Answer

Joe Stefanelli picture Joe Stefanelli · Sep 17, 2010

Have you checked to make sure your connection string is correct in your web.config file?

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
   <add 
     name="MyNewConnection" 
     connectionString= "server=myServer;database=myDatabase;uid=username;pwd=password"
     providerName="System.Data.SqlClient" /> 

  </connectionStrings>
</configuration>

Related questions

sqlexpress local database administrator password

I'm trying to install some .Net eCommerce projects on my local machine (windows Vista) with Webmatrix. Some of them ask for a Database administrator username and password, but I have no idea what those are. Can anybody help me on …

Read More
What to use to open an .mdf (SQL Database) file

I was hoping to be able to open .mdf file. I am using WebMatrix, I can view the queries there. I can read the schema too. But how can I read the file without using WebMatrix. Its SQL Server file …

Read More
The name 'Database' does not exist in the current context?

I am getting this error when I try to launch my website using WebMatrix. I have a .cs file which makes a call var db = Database.Open("dbase");. I have a database in my project called "dbase". I have no …

Read More