SqlServerCE and ASP.NET Configuration
-
I can't quite decide where this belongs, because of what I'm trying to do. I'm not actually creating a website / webpage etc. so I'm not sure it belongs in ASP.NET forum, and I'm not actually trying to do anything (yet) with the database, so not SqlServer forum. What I am trying to do is.... pass an ASP.NET webpage an XML message for it to then call a dll and create / populate / return and SqlServerCE datafile. So far, I have the flag set to allow ASP.NET to work with Mobile databases, I've got that far. I've installed the .NET Framework 3.5 on the server, but when I try to make a call to an SqlCeConnection object, I get an error about not being able to find the assembly System.Data.SqlServerCe 3.5.0.0. What am I missing to be able to communicate?
-
I can't quite decide where this belongs, because of what I'm trying to do. I'm not actually creating a website / webpage etc. so I'm not sure it belongs in ASP.NET forum, and I'm not actually trying to do anything (yet) with the database, so not SqlServer forum. What I am trying to do is.... pass an ASP.NET webpage an XML message for it to then call a dll and create / populate / return and SqlServerCE datafile. So far, I have the flag set to allow ASP.NET to work with Mobile databases, I've got that far. I've installed the .NET Framework 3.5 on the server, but when I try to make a call to an SqlCeConnection object, I get an error about not being able to find the assembly System.Data.SqlServerCe 3.5.0.0. What am I missing to be able to communicate?
hammerstein05 wrote:
I get an error about not being able to find the assembly System.Data.SqlServerCe 3.5.0.0. What am I missing to be able to communicate?
The obvious answer based on your post is "the assembly". So either you don't have the correct version installed or your runtime environment isn't looking where you installed it. So I imagine some reading of the different parts of your runtime environment and how they locate assemblies. Keep security issues in mind as they can play into locating assemblies when it comes to things like using the GAC. Also it's always a good idea to post the exact error message rather than your interpretation of it.
led mike
-
hammerstein05 wrote:
I get an error about not being able to find the assembly System.Data.SqlServerCe 3.5.0.0. What am I missing to be able to communicate?
The obvious answer based on your post is "the assembly". So either you don't have the correct version installed or your runtime environment isn't looking where you installed it. So I imagine some reading of the different parts of your runtime environment and how they locate assemblies. Keep security issues in mind as they can play into locating assemblies when it comes to things like using the GAC. Also it's always a good idea to post the exact error message rather than your interpretation of it.
led mike
The most obvious answer was indeed the answer. My understanding of the .NET framework grew a little today. In order to have the SqlServerCe assembly available, I didn't need to have the .NET Framework 3.5 installed, I need to have Sql Server Mobile 3.5 installed. With that installed, and the flag set in the ASP.NET script I'm now happily manipulating mobile databases. Just for the record though, I'm not trying to write ASP.NET websites using mobile databases, I understand the limitations. I'm using the pages to call from a mobile application.