View Complete Post
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
C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Private\x86
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
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
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:
>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?
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
hello from switzerland !
I am trying to use the SqlServerCe DLL in a Windows Forms app being built in Visual C# 2010 Express. I notice that this DLL is not integrated with other .NET 3.5 and 4.0 DLLs in the Program Files Reference Assemblies on my system (Windows XP), but
is rather isolated in the Program Files => SQL Server Compact Edition directory. While that is not an inherently big problem as far as I can tell, it does mean that System.Data.SqlServerCe doesn't always show up or show up where you would expect
it in various Visual Studio dialogue boxes. For example, when doing an Add Reference and using the .NET source for DLLs, the SqlServerCe DLL does not show up in alphabetical orger with the other System.Data.* namespaces. It took quite
awhile before I stumbled on it, which triggered the realization that it is not intergrated with the other .NET components. It seemed to me there have been other times in researching SqlServerCe that I wasn't finding things when I was expecting (recognizing
that I have limited experience with this stuff so far).
Three questions: (1) Is using System.Data.SqlServerCe still a proposed means to interface with SSCE programmatically (using Visual C# 2010 Express); (2) Might I have done something to (inadvertently) cause SqlServerCe to install outside the bulk
of .NET (I frankly can't remember h
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 22.214.171.124 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
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=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
On web.config I already have this:<add assembly="System.Data.Linq, Version=188.8.131.52, 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?
The System.Transactions namespace of the Microsoft .NET Framework makes handling transactions much simpler than previous techniques. Read all about it this month.
MSDN Magazine November 2006
The MicrosoftÃÂ® . NET Framework versions 1. 0 and 1. 1 represented major changes in software development. However, one important thing that did not change much was support for distributed transactions.
MSDN Magazine February 2005
The Web Storage System (WSS) in Exchange 2000 is a Web-accessible database that stores any type of data such as e-mail, contacts, appointments, threaded discussions, and multimedia files, and renders the data in HTML in any browser. WSS is based on Internet standards, therefore data can be accessed through URLs, an Exchange OLE DB provider, drive mapping, XML, and Web Documenting and Versioning (WebDAV). This article discusses the WSS schema and how to extend the default schema for custom data. A sample application that uses a custom schema and a custom form to display WSS data is available for download.
MSDN Magazine May 2001
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) Fed Up With System.Data.Metadata.Edm.ObjectItemAssemblyLoader I'm fed up with the random errors I'm getting on my ASP.NET 4, Entity Framework 4 web application lately. It seems to stem from something that System.Data.Metadata.Edm is doing with a call to System.Reflection.Assembly.GetTypes(). I keep getting the error that I complained about previously : Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. To display those Loader exceptions, I added the following to my global.asax file: Sub Application_Error...(read more)
Categories: ASP.NetWindows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All