using a sfd file

  • Thread starter Thread starter Tony Johansson
  • Start date Start date
T

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
 
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.
Click to expand...

Neither.

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

Arne
 
Arne Vajhøj said:
Neither.

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

Arne
Click to expand...

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

//Tony
 
I have not downloaded any SQLServer CE so which engine is that handle the
request that I made from my program ?
Click to expand...

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
 
Back
Top