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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

protection against older version uploads

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
(using SQL Server 2005) I just changed some things in my SQL server database.  This will require an update to the user program that uploads and downloads from the database, but I am starting to wonder about protecting the database against uploads from old program versions.  Theoretically everyone should be using the latest program version, but if they aren't then there is a possibility they could upload data to the database with routines that no longer should be used.  Is there a standard way to protect against out-of-date upload routines?

View Complete Post

More Related Resource Links

Newbie-Can I remove older version of .NET Framework

Hey,Got different versions on my Windows XP; 1.12.0 Service Pack 22.0 SP 2 - Language Pack3.0 SP 23.0 SP 2 - Language Pack3.5 SP 11- For obvious reasons these take a lot of space, can I remove any of them and which?  2- Are they a built up or separate?  3- If I can only use the latest 3.5 SP1;  is there a language pack with it?4- I have not been able to update anything for over a year.  It keeps telling me, Windows has some new installs for me but won't download properly.  Sorry I can't tell you the specific error it gives me, but I believe it has to do with a previous version as it is related to a Service Pack 2.  Sorry I know it's vague, but it takes for ever before I get the error message.  If you can't give me any idea, I'll try it again and post more info.In the meantime I'd appreciate any help you people can give me.Sunshine

Need older version of SQL2008 Standard

I downloaded the SQL2008 standard from the partner site, but the version number is beyond my host's version and so databases cannot be restored to his site.  How can I get a SQL2008_Standard_version 10 from the partner site?

Older version of database - Baffled!



I've installed all the 3.5 cabs, pointing to the latest SqlServerCE.dll, still can't open a connectiong to a SQL Compact Database. I'm using VS 2008, I can open a SqlCE 3.0 DB but not 3.5. I keep getting

"You are trying to access an older version of a SQL Server Everywhere database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. If this is a SQL Server Everywhere 3.0 database, run Compact / Repair. [ Db version = 3505053,Requested version = 3004180,File name = ---\DB.sdf ].

I'm able to open the sdf from the device Query Analyser, just dunno, what's going on -- Any ideas would be very helpful!

Thank you,



Exception deserializing objects from older version



We have a fairly complex document structure for our application, which we are saving to disk using Binary Serialization. We came across the familiar problem, that when we incremented the version number of our application (to allow an MSI installer to upgrade it), the Deserialize method on files created with the old version no longer worked. After some research, I came up with the solution to define our own SerializationBinder, and implement a BindToType function that substututes the types. I've stuck the code for this below:

 Public Overrides Function BindToType(ByVal assemblyName As String, ByVal typeName As String) As Type
  Dim typeToDeserialize As Type = Nothing
  Dim ThisAssembly As [Assembly] = [Assembly].GetExecutingAssembly()

  If typeName Like "MyApp*" Then
   ' To return the type, do this:
   AddErrorMessage("Deserializing " & typeName & " " & ThisAssembly.FullName)
   typeToDeserialize = Type.[GetType]([String].Format("{0}, {1}", typeName, ThisAssembly.FullName))
   ' To return the type, do this:
   AddErrorMessage("Deserializing " & typeName & " " & assemblyName)
   typeToDeserialize = Type.[GetType]([String].Format("{0}, {1}", typeName, assemblyName))
  End If
  If typeToDeserialize Is Nothing Then

ASP.NET 4.0: WebForm Routing (quick n dirty version)

One of the things we're adding in ASP.NET 4.0 is built-in support for using Routing together with WebForms. Now, I'm totally aware that this is possible to do already and that a number of people have posted ways of doing this with the Web Routing feature which shipped with ASP.NET 3.5 SP1. We're just adding some features to make it easier to do

how to create a mobile version of a website?


 how to create a mobile version of a website?
Is there any server support needed?
How does the browser detect whether the url is accessed via mobile device or a PC?

Coding Tools: Improved Support For Parallelism In The Next Version Of Visual Studio


We take a look at planned support for parallel programming for both managed and native code in the next version of Visual Studio.

Stephen Toub and Hazim Shafi

MSDN Magazine October 2008

Team System: Team Foundation Server Version Control


In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007

C++ at Work: Web Version Checking, Adding Sound to an App


This month: CWebVersion revisited using HTTP instead of FTP, and adding sounds to an MFC-based app.

Paul DiLascia

MSDN Magazine May 2006

XML in Yukon: New Version Showcases Native XML Type and Advanced Data Handling


The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQuery language. Data integrity of the XML data type can be enforced through schema validation and XML-based check constraints, and special indexes can be defined that help speed up queries. In addition, Yukon has the built-in ability to expose its data through Web services. This article discusses these and other XML features of Yukon.

Bob Beauchemin

MSDN Magazine February 2004

Windows CE.NET: New Version Offers Revamped Platform Builder, Improved Tools, Enhanced API, and Sour


Windows CE .NET, the newest member of the .NET family, includes a number of improvements over previous versions of Windows CE. For example, there are quite a few new APIs and enhancements to security and connectivity, the user interface, the kernel, and the emulator. In addition, DirectX support has been added and C++ in Windows CE .NET now supports C++ exceptions, STL, and runtime type information. In this article the author takes a tour of Windows CE .NET, starting with the New Platform Wizard that allows you to code for your choice of devices. A sample application is included that locates features on portable devices so the reader knows what's available before writing code.

Paul Yao

MSDN Magazine July 2002

Beyond Windows XP: Get Ready Now for the Upcoming 64-Bit Version of Windows


In this article the author modifies an industry standard middle-tier application server benchmark called Nile. The goal was to get it to build and run correctly on the 64-bit edition of the Microsoft .NET Advanced Server running on computers with Intel Itanium processors and still build as a 32-bit version to run on Pentium class x86 processors. While modifying Nile, the author discovered some of the tips he presents here. As the article explains, when modifying code for 64-bit Windows, data types are the key to success. The article discusses which types to use and when, along with new data types and the importance of memory alignment.

Stan Murawski

MSDN Magazine November 2001

ISAPI Extensions: Creating a DLL to Enable HTTP-based File Uploads with IIS


The MIME-compliant content type, called multipart/form-data, makes writing HTML that uploads files almost trivial. On the server side though, ASP does not have a way to access data in the multipart/form-data format. The most flexible way to access the uploaded file is through a C++ ISAPI Extension DLL. This article describes a reusable ISAPI extension DLL that allows you to upload images and files without writing C++ code. It is coupled with a few COM components that make it readily reusable for ASP development. With .NET, this whole process is much easier, and this article shows preliminary code that uploads files using ASP.NET features.

Panos Kougiouris

MSDN Magazine October 2001

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices


Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

Paul Yao and David Durant

MSDN Magazine June 2001

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