Wiki Link: [discussion:872]
Connection Between Visual Studio Express 2008 and SQL Server 2008 

Oct 30 2008 at 2:20 PM
Beth, I must state that as an IT teacher with managment responsibilities I find the resources you have put together fantastic. We have started a new A level course (Key Stage 5 i.e. post 16) at my school and have traditionally written similar resources to yours in my schemes of work. It is so good to be able to point A level students to these resources to help build their skills independently.

My question is a simple one. In your creating a database video you start off the demonstration by right clicking data connections, then clicking Create New SQL Server Database. This option is greyed out for me despite having Visual Studio 2008 Express and SQL Server 2008 with Tools installed. The SQL Sever Management Studio works fine and I can add Data Connections to mdf and mdb files from Visual Studio 2008 Express.

Thanks for your time.

Dec 10 2008 at 7:52 AM
Hi Rafel,

I'm not really sure why that is happening. I found a thread here where others were experiencing the problem:

Try this:

When the Database Explorer window is open, there are three icons at the top. Click the one to the right, the orange cylinder representing a database connection. When you hover your mouse over it, the tool tip will show "Connect to Database". A new window will open. The cursor will be in a box and the box label says "Database file name(new or existing). To create a new db, browse to the folder you want it to be in and then type in the name you want it to have and when you exit the box the OK button will be available. Click it and a msgbox will tell you the database doesn't exist and asks if you want to create it. Click Yes and it will appear in the Database Explorer window.


Page view tracker