.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Deployment error system.data.sqlserverce version 3.5.1.0 glabal assembly cache

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

I have upgraded my development environment from Visual C# 2008 Express on Windows XP to Visual C# 2010 Express running on Windows 7 that uses SQLCE SP2.  I use a private deployment of the SQLCE 32-bit and 64-bit libaries and for the past year has wworked fine deploying to all systems.  Since upgrading I have been unable to produce a successful deployment.  I get an error almost immediately when my program attempts to update

system.data.sqlserverce version 3.5.1.0 glabal assembly cache

I have been attempting to do the deployment on a Windows 7 64 bit machine.  Does anybody have any ideas what I can do to eliminate this issue.  I have ensure that my build is targeting .NET 3.5

Dave


David Allen


View Complete Post


More Related Resource Links

File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF

  
I have Encountered with this problem when i am doing project for mobile application. I have installed sqlce.dev.ENU.ppc.wce5.armv4i.CAB,sqlce.repl.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,NETCFv2.wm.armv4i.cab My Deployment Cab File NewBatchScanCab_Data.CAB with all this following cab's. This Cab is running in another Computer's also but it is prompting error message as below: File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF1C8D2AD3',or one of its dependencies,was not found. I Wanna now why it is prompting this error message.

File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF

  
I have Encountered with this problem when i am doing project for mobile application. I have installed sqlce.dev.ENU.ppc.wce5.armv4i.CAB,sqlce.repl.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,NETCFv2.wm.armv4i.cab My Deployment Cab File NewBatchScanCab_Data.CAB with all this following cab's. This Cab is running in another Computer's also but it is prompting error message as below: File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF1C8D2AD3',or one of its dependencies,was not found. I Wanna now why it is prompting this error message.

system.io.fileloadexception - could not load file or assembly system.data.sqlserverce version=3.5.1.

  

 

my application raises this exception but the file system.data.sqlserverce.dll is in the folder of the application, and the version is correct.

 

do u have any idea about this problem ?

 

thanks in advance for every answer Smile

 

hello from switzerland !

 

steve


Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0,...

  
We have an application that runs on both Windows Mobile and Desktop, both which are now using SQL Server Compact 3.5 SP1 as the database.  Everything is working great on the WM side in debug and runtime, but on the desktop side we are getting the following error.

"Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=3be235df1c8d2ad3, Retargetable=Yes' or one of its dependencies.  The given assembly name or codebase was invalid.  (Exception from HRESULT: 0x80131047)"

I do not get this error when I run in debug mode for the desktop app, but if we install the application to a Vista (32bit) or Windows Server 2003 (32bit) machine we get the error.  The only thing I can point at that is different between all the different machines we have tried this on is that it always works if Visual Studio is installed on the machine.  

Our current deployment method is to mark the System.Data.SqlServerCe (3.5.1.0) reference to Copy Local=False and then we package the SQL Server Compact 3.5 SP1 installer with our installation program.  I have verified that the dll's are in the GAC with the correct version, but the application cannot find an assembly.  I have also tried copying all the sqlce*.dll files (a

The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must

  

Hi,

This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
        {
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        }


Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

 

On web.config I already have this:
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?

Thanks.


Business Data Error: System.OverFlowException

  

I have a Business Data Catalog file I've uploaded to connect to our back end Firebird DBMS through ODBC.

The SharePoint server is MOSS 2007 x64. The web front end server(s) all have an x64 Firebird Engine and ODBC driver with verified connectivity to Firebird.

When I use one of the methods, I can see connections being made to our Firebird server and the query being passed. I know the query returns results (it's a stored procedure with no parameters), but I get the following error "An error occurred while retrieving data from MROTest1. Administrators, see the server log for more information" in IE. If I look in the server logs, I see (12\Hive\Logs)

Exception handed to HandleRuntimeException.HandleException System.OverflowException: Arithmetic operation resulted in an overflow.     at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb, Int32& cbActualOut)

Add System.Data.SqlServerCE

  
Hi I have a web application using visual studio 2005 and i want to use the namespaces System.Data.SqlServerCe on my asp.net page. But i couldnt find the the dll from the AddReference Dialog. Please help!!!!   Regards, LINOO   

Could not load file or assembly "System.Data.DLL" or one of its dependencies

  
Could not load file or assembly "System.Data.DLL" or one of its dependencies

Assembly load error system.runtime.serialization

  
Hello ! I have a web project which i began there is some month, and compile perfectly until now. In fact, i have some compile error;   erreur 1 Could not load file or assembly 'System.Runtime.Serialization, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The module was expected to contain an assembly manifest.   on explorer :   The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018) Description : Une exception non gérée s'est produite au moment de l'exécution de la demande Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code. Détails de l'exception: System.BadImageFormatException: The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018) Erreur source: Une exception non gérée s'est produite lors de l'exécution de la demande Web actuelle. Les informations relatives à l'origine et l'emplacement de l'exception peuvent être identifiées en utilisant la trace de la pile d'exception ci-dessous. Trace de la pile: [BadImageFormatException: The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018)] System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBa

Imports System.Data.SqlServerCE on Web application

  
Hi everybody, Can we import System.Data.SqlServerCe namesapce to web application? I tried to add The SqlServerCe namespace from AddReference dialog but it didnt show. And I have tried to install compact framework 3.5 but it still the same not show. My requirements are Login to the website and then create a database[.sdf] on the mobile device. Then connect to the .sdf file to retrieve info and display on my webpage. The window mobile device is running on Window CE 5.0 OS. And I'm using MS Visual Studio 2005.   HELP!!!!!!HELP!!!!!!     LEENO

Framework error:Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0

  
Hi,I use sql clr sp's to load data in to database using .net framework 2.0. I never had aproblem using this and it went well for months.I recently updated to net framework 3.5 sp1 and sqlserver sp3 on 32-bit sql server and win 2003.I am facing an error which i could not resolve.Error:System.IO.FileLoadException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)System.IO.FileLoadException:    at StoredProcedures.checktable(String paramComponent, String paramParameters)I have gone through different forums, and trie different options,but did not help. I am using 'unsafe'  option.I also tried to alter assembly which is mentioned in http://support.microsoft.com/kb/949080/pt But when i tried to alter the assembly using the above link or try to change the permission to external access on the assembly, i get the below error.Alter ASSEMBLY AccessibilityFROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Accessibility.dll'Cannot alter the assembly 'Accessibility', because it does not exist or you do not have permission.I am an admin on the server/sqlCan some one suggest how to alter assembly with permissions or solve this issue or am i missing anything important.Do i

Creating assembly throwing an error as system.directoryservices assembly is not in the SQL Server

  
Hi, I am trying to create an assembly (DLL file that created by C# ) which uses System.DirectoryServices assembly. When I try with following script Create ASSEMBLY Addresstype From 'C:\ActiDirectoryFunctions\ActiveDirectoryFunctions.dll' I am getting following Error Assembly 'ActiveDirectoryFunctions' references assembly 'system.directoryservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. From above error message, I learnt that System.DirectoryServices assembly is not in the SQL Server. I am using SQL SERVER 2005 SP2 and .Net Framework 3 is there in the machine How to manually add this assembly into this SQL Server Machine? Please let me know if you know Thank you, Raj Dreaming a world without any war in anywhere

SQL Compact 3.5 on WinCE5.0 System.Data.SqlServerCe.dll or one of its dependencies, was not found

  
Hi community, I'm trying to get SQL Compact SP(1, 2) in my NK.BIN (WinCE500, Arm4I). PB builds the image, it boots correctly. On the mobile device, all of these files are present in the \Windows folder: GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll sqlceca35.dll sqlcecompact35.dll sqlceer35EN.dll sqlceme35.dll sqlceoledb35.dll sqlceqp35.dll sqlcese35.dll In the registry, these settings are present: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETCompactFramework\Installer] "GACPath"="\\Windows" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETCompactFramework\Installer\Assemblies\Global] "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3"=hex(7):\       5c,77,69,6e,64,6f,77,73,5c,47,41,43,5f,53,79,73,74,65,6d,2e,44,61,74,61,2e,\       53,71,6c,53,65,72,76,65,72,43,65,5f,76,33,5f,35,5f,31,5f,30,5f,63,6e,65,75,\       74,72,61,6c,5f,31,2e,64,6c,6c,00,53,79,73,74,65,6d,2e,44,61,74,61,2e,53,71,\       6c,53,65,72,76,65,72,43,65,2e,64,6c,6c,00,00,00,00,00,00 ; Which is \windows\GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll System.Data.SqlServerCe.dll [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETCompactFramework\Installer\Assemblies\ROM] "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyT

Could not load file or assembly '0 bytes loaded from System, Version=2.0.0.0, Culture=neutral, Publ

  
Hi I have a clickonce deployed application in my machine. When I tried to load the application, 90% of the application window is getting loaded but finally, I get the following error: Could not load file or assembly '0 bytes loaded from System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. An attempt was made to load a program with an incorrect format. I have read somewhere that this error could be caused when something goes wrong with the .net framework in the machine. My machine is having .Net framework 2.0, 3.0 and 3.5. So which framework should I reinstall? The application is developed using .net 2.0. Also, please let me know how the application is partially loading(90%) if the framework is corrupted.? Regards Anoop.

System.Data.SqlServerCe Missing in \.NETFramework\v4.0

  

Hi,

I am trying to install SQL Compact Edition on Windows 7 desktop Home Edition.  I am using visual studio C# 2010 Express Edition and have SQL Express 2008

When I add "using System.Data.SqlServerCe", SqlCeConnection, isn't referenced.  I cannot find/add System.Data.SqlServerCe as a .NET reference.  When I navigate to C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0.  SqlServerCe isn't present.  However, I can find the necessary file within

C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Private
System.Data.SqlServerCe.dll
System.Data.SqlServerCeEntity.dll

C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Private\x86
sqlceca40.dll
sqlcecompact40.dll
sqlceer40EN.dll
sqlceme40.dll
sqlceqp40.dll
sqlcese40.dll

When I add a reference to C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Private\System.Data.SqlServerCe.dll, SqlCeConnection, turns blue and is refereced.  But wh

Unhandled exception in XAML editor from control that accesses database. - "System.Data.SqlServerCe.S

  

Hello,

Im having a bit of difficulty with some WPF/C#/SQL Server CE code.

I have a WPF User Control with the following line of code in the constructor:

MyDatabase database = new
 MyDatabase("Data Source=|DataDirectory|\\MyDatabase.sdf"
 );

where MyDatabase is a class generated using SQLMetal.exe from MyDatabase.sdf.

 

When I added this control to other controls, the application runs fine and I'm able to access my database. When I try to edit these parent controls,  the XAML editor throws the following error:

 

>System.Data.SqlServerCe.SqlCeException
>The database file cannot be found. Check the path to the database. [ Data Source = D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\MyDatabase.sdf ]

 

Why does the XAML editor redirect my DataDirectory to "D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\" and why does the XAML editor execute my database access code?

 

How can I fix this so I can use this control in a XAML editor?

Thanks,

Greg S.

 


Unhandled exception in XAML editor from control that accesses database. - "System.Data.SqlServerCe.S

  

Hello,

Im having a bit of difficulty with some WPF/C#/SQL Server CE code.

I have a WPF User Control with the following line of code in the constructor:

MyDatabase database = new
 MyDatabase("Data Source=|DataDirectory|\\MyDatabase.sdf"
 );

where MyDatabase is a class generated using SQLMetal.exe from MyDatabase.sdf.

 

When I added this control to other controls, the application runs fine and I'm able to access my database. When I try to edit these parent controls,  the XAML editor throws the following error:

 

>System.Data.SqlServerCe.SqlCeException
>The database file cannot be found. Check the path to the database. [ Data Source = D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\MyDatabase.sdf ]

 

Why does the XAML editor redirect my DataDirectory to "D:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\" and why does the XAML editor execute my database access code?

 

How can I fix this so I can use this control in a XAML editor?

Thanks,

Greg S.

 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend