|
|
|
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"
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Today @ 5:38 PM
Points: 3,910,
Visits: 10,541
|
|
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
help us help you! if your post doesnt have CREATE TABLE YOURTABLENAME and INSERT INTO YOURTABLE SQL statements, chances are you didn't post enough information for us to help you! If you can, avoid pseudocode and show us your actual query...it makes it much better for you to see a good example with your tablenames you'd understand, and be able to copy and paste for immediate testing.
|
|
|
|
|
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
|
|
|
|
