I've written programs in the past using MDBs as portable databases. I've created and used SDFs in devices and was writing a conversion app that lets the user select an existing MDB from their desktop and I first convert the MDB into a dataset with
as many tables as are in the MDB. Got that working well though I'm not getting the schema for datatypes etc. this way. So then I added a MDB as a new datasource and that created the XSD.
But aside from that I am simple trying to create a SDF database in code from within a WinForm application so I'll have a SDF to insert the dataset into- I'm working in VS2005
ds As DataSet)
String = Path.GetFileName(txtPathtoMDB.Text)
String = Replace(txtPathtoMDB.Text,
String = SDFPath
'the following line gives this error:Format of the initialization string does not conform to specification starting at index
New SqlCeEngine(ConnStr) 'ConnStr = "C:\NewDB.sdf"
As you see above I'm getting a wierd error just trying to create a new SDF - what am i missing. This is allowed to create a SDF database on the desktop
View Complete Post