Groups | Blog | Home
all groups > sql server new users > april 2007 >

sql server new users : Connecting to an SQL Server Express Database with C++ or C# Express


Wayne
4/7/2007 12:00:00 AM
I have installed an .sdf database (consisting of two tables right now) and I
want to create a front end, ideally using Visual C++ but I also want to
learn C#. I have created Windows projects in both and attempt to create a
new database connection, however both are looking for an mdf file even
though the connection choice is an SQL Server client, not the sdf file
created by SQL Server. Any ideas on how I can connect to the database ?
Han Folstofe
4/9/2007 12:00:00 AM
The sdf file is for SQL Server 2005 Compact Edition (mobile) and not for the
express edition
You will need the ADO.net drivers that reside in the following namespace
System.Data.SqlServerCe

hth
Vikram

[quoted text, click to view]

Aaron Kempf
5/2/2007 7:13:50 PM
I don't really like that

why doesn't the mobile edition WORK with the real version?

it should be a portable MDF-- ONE SINGLE FORMAT


[quoted text, click to view]

AddThis Social Bookmark Button