can't add data source in Visual Studio with SQL Server ce 3.5

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » can't add data source in Visual Studio with...

can't add data source in Visual Studio with SQL Server ce 3.5

Rate Topic

Display Mode

Topic Options

Author

Message

ericvanderhousen

Posted Wednesday, February 03, 2010 7:30 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 03, 2010 9:28 AM
Points: 12, Visits: 21

using SQL Server CE 3.5 with Visual Studio 2008, but, when I add a sdf file, I keeping getting the error "an error occurred while creating the new data source"

Post #858658

Lowell

Posted Wednesday, February 03, 2010 8:45 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:39 PM
Points: 11,638, Visits: 27,713

eric could it have to do with disk permissions?

for example, on my win7 laptop, i cannot write to c:\mydb.sdf, but i have no problem writing to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mydb.sdf

but on my xp desktop, i can write to either place, mostly because my desktop is runnign with service credentials of a local admin, instead of whatever the default local service or network service account.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #858759

ericvanderhousen

Posted Wednesday, February 03, 2010 9:39 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 03, 2010 9:28 AM
Points: 12, Visits: 21

thanks for the reply, but, the sdf file, is not readonly?
rather, I cannot add it to Visual Studio, as a new data source

Post #858816

boyeosomo

Posted Tuesday, March 29, 2011 6:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 6:50 AM
Points: 1, Visits: 0

I am having the same problem too. Is anyone able to explain what needs to be done here. I am unable to progress with my project as i cannot add any data tables to the data source window. When trying to conenct to the data source get the same error listed above. Please HELP!

Post #1085476

« Prev Topic | Next Topic »

Permissions