using a sfd file

[Tony Johansson]

Hello!

I use VS2008 and have done the following.
1. I have added a new item which is a local Database that I have called myDB
from the Templates.
2. I have created a new table and called it Friends in this myDB Database
and this create a Friends.sdf file
3. I have added some rows in this Friends table.

I can use a program to read from this table and everything works fine.

Now to my question
I have both SQL Server 2005 and SQL Server 2008 installed and wonder if it's
SQL Server 2005 express or
SQL Server 2008 or some other part in any of these two that is handling the
request from my program.

I have never used sdf files before.
//Tony

 

[Arne Vajhøj]

I use VS2008 and have done the following.
1. I have added a new item which is a local Database that I have called myDB
from the Templates.
2. I have created a new table and called it Friends in this myDB Database
and this create a Friends.sdf file
3. I have added some rows in this Friends table.

I can use a program to read from this table and everything works fine.

Now to my question
I have both SQL Server 2005 and SQL Server 2008 installed and wonder if it's
SQL Server 2005 express or
SQL Server 2008 or some other part in any of these two that is handling the
request from my program.

I have never used sdf files before.

Neither.

..SDF is SQLServer CE (Compact Edition), which is a different database
even though the name sounds very much like SQLServer.

Arne

 

[Tony Johansson]

Neither.

.SDF is SQLServer CE (Compact Edition), which is a different database
even though the name sounds very much like SQLServer.

Arne

I have not downloaded any SQLServer CE so which engine is that handle the
request that I made from my program ?

//Tony

 

[Arne Vajhøj]

I have not downloaded any SQLServer CE so which engine is that handle the
request that I made from my program ?

SQLServer CE

It must have been installed with something else.

It may even come with Visual Studio.

Check if you have a:
C:\Program Files\Microsoft SQL Server Compact Edition

Arne