 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Languages / C# / February 2008Missing sqlceme35.dll
I am trying to write an application that pulls data out of a SQL Server CE database file, an SDF file. It works just fin on my computer (running XP Pro). But when a co-worker tries to run it on his XP Pro computer, he gets an error that it is unable to load a DLL, namely sqlceme35.dll. I am wondering why the application runs fine on my computer but not his? The app was installed on both computers using a Setup project MSI file. Developed with VS2008 with Target Framework set to 2.0. On Feb 29, 6:29 pm, za...@construction-imaging.com wrote: > I am trying to write an application that pulls data out of a SQL > Server CE database file, an SDF file. It works just fin on my computer [quoted text clipped - 9 lines] > > Developed with VS2008 with Target Framework set to 2.0. I think you should copy the DLL on co-worker's computer's system32 directory then register it via regsvr32. > On Feb 29, 6:29 pm, za...@construction-imaging.com wrote: > [quoted text clipped - 14 lines] > I think you should copy the DLL on co-worker's computer's system32 > directory then register it via regsvr32. That is an unaccepatable solution. We expect to eventually distribute this application to our customers, and would prefer that the setup includes everything that is needed. I tried to add the DLL as a reference but VS2008 would not let me. That looks to be an assembly distributed with SQL Server Compact Edition 3.5. Do you actually have that installed on the other machine?  Signature- Nicholas Paldino [.NET/C# MVP] - mvp@spam.guard.caspershouse.com >I am trying to write an application that pulls data out of a SQL > Server CE database file, an SDF file. It works just fin on my computer [quoted text clipped - 9 lines] > > Developed with VS2008 with Target Framework set to 2.0. On Feb 29, 11:43 am, "Nicholas Paldino [.NET/C# MVP]" <m...@spam.guard.caspershouse.com> wrote: > That looks to be an assembly distributed with SQL Server Compact Edition > 3.5. Do you actually have that installed on the other machine? Not yet, but will try. But the question is why? IMHO, you shouldn't have to. > <za...@construction-imaging.com> wrote in message > [quoted text clipped - 13 lines] > > > Developed with VS2008 with Target Framework set to 2.0. Well, yes, you should, because the EULA for SQL Server Compact Edition 3.5 probably says that you can't redistribute parts of the install, but have to install the whole thing. AFAIK, the dll you are looking for is not a part of the .NET framework. Signature- Nicholas Paldino [.NET/C# MVP] - mvp@spam.guard.caspershouse.com On Feb 29, 11:43 am, "Nicholas Paldino [.NET/C# MVP]" <m...@spam.guard.caspershouse.com> wrote: > That looks to be an assembly distributed with SQL Server Compact Edition > 3.5. Do you actually have that installed on the other machine? Not yet, but will try. But the question is why? IMHO, you shouldn't have to. > <za...@construction-imaging.com> wrote in message > [quoted text clipped - 13 lines] > > > Developed with VS2008 with Target Framework set to 2.0. > I am trying to write an application that pulls data out of a SQL > Server CE database file, an SDF file. It works just fin on my computer [quoted text clipped - 9 lines] > > Developed with VS2008 with Target Framework set to 2.0. Your app needs: System.Data.SqlServerCe.dll sqlceme35.dll sqlceqp35.dll sqlcese35.dll The first is a .NET assembly. The last 3 are Win32 DLL's. Nothing need to be installed. Just put the 4 DLL's in same dir as your EXE. Arne For more information on SQL Compact deployment, see http://msdn2.microsoft.com/en-us/library/bb219481.aspx SignatureErik Ejlskov Jensen, Mobile App Dev MCTS Check out my SQL Compact blog at http://erikej.blogspot.com >> I am trying to write an application that pulls data out of a SQL >> Server CE database file, an SDF file. It works just fin on my computer [quoted text clipped - 23 lines] > > Arne > For more information on SQL Compact deployment, see > >http://msdn2.microsoft.com/en-us/library/bb219481.aspx OK, this was the best suggestion yet. But this page did not go quite far enough. For the files to be installed on the application folder, you also MUST add all seven of the files to the Application Folder in the Setup project. Now, the real mystery is, how come this application ever ran just fine for me before I added these DLLs to the project at all?!? > > za...@construction-imaging.com wrote: > >> I am trying to write an application that pulls data out of a SQL [quoted text clipped - 26 lines] > > - Show quoted text - SQL Compact is installed globally on your machine (as part of VS 2008, perhaps?). Your colleague did not have SQL Compact installed. SignatureErik Ejlskov Jensen, Mobile App Dev MCTS Check out my SQL Compact blog at http://erikej.blogspot.com On Feb 29, 1:29 pm, "ErikEJ" <ejls...@hotmail.com> wrote: > For more information on SQL Compact deployment, see > >http://msdn2.microsoft.com/en-us/library/bb219481.aspx OK, this was the best suggestion yet. But this page did not go quite far enough. For the files to be installed on the application folder, you also MUST add all seven of the files to the Application Folder in the Setup project. Now, the real mystery is, how come this application ever ran just fine for me before I added these DLLs to the project at all?!? > "Arne Vajhøj" <a...@vajhoej.dk> wrote in message > [quoted text clipped - 30 lines] > > - Show quoted text - > za...@construction-imaging.com wrote: > > I am trying to write an application that pulls data out of a SQL [quoted text clipped - 24 lines] > > Arne Actually, if OP refenced DLLs and builded/run the app(exe), i think they must have been copied to the app's folder automatically. > > za...@construction-imaging.com wrote: > > > I am trying to write an application that pulls data out of a SQL [quoted text clipped - 27 lines] > Actually, if OP refenced DLLs and builded/run the app(exe), i think > they must have been copied to the app's folder automatically. Visual Studio will not allow me to add these DLLs as references. Claims that they are not valid assemblies. >>> za...@construction-imaging.com wrote: >>>> I am trying to write an application that pulls data out of a SQL [quoted text clipped - 21 lines] > Visual Studio will not allow me to add these DLLs as references. > Claims that they are not valid assemblies. The last 3 are Win32 DLL's not .NET assemblies. Arne On Feb 29, 8:47 pm, za...@construction-imaging.com wrote: > > > za...@construction-imaging.com wrote: > > > > I am trying to write an application that pulls data out of a SQL [quoted text clipped - 32 lines] > > - Show quoted text - That's annoying if the assemlies are really valid. However in VB 2005, i also can't reference some DLLs which are denied by VS claiming they're not COM-compatible or valid assembly or kinda errors..For my subject's DLL, I suspect they're written as unmanaged DLLs plus suspecting that they are written in C++. For example i can'T reference that DLL on a VB site on VB 2005: http://www.vbcodesource.org/downloads/encoderex.zip > za...@construction-imaging.com wrote: > > I am trying to write an application that pulls data out of a SQL [quoted text clipped - 22 lines] > Nothing need to be installed. Just put the 4 DLL's in same > dir as your EXE. OK, I already had the first file since it was a reference in the project. I manually added the other three. I do not get the unable to load DLL error, but I do get an error when trying to open the connection. Exception message is "Unspecified error". > OK, I already had the first file since it was a reference in the > project. I manually added the other three. I do not get the unable to > load DLL error, but I do get an error when trying to open the > connection. Exception message is "Unspecified error". Can we get the complete exception text ? And maybe a code snippet around the relevant line ? Arne Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.