473,507 Members | 2,545 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SqlDateTime overflow if using .NET Remoting and Windows XP

Hello,

I am getting SqlDateTime overflow if I use .NET remoting on Windows XP and
Windows XP is the server where the SQL server is located at. If my computer
is Windows 2003 where the sql server is running and I use client as the
windows XP I do not get this error.
--
Mike
Sep 26 '06 #1
3 2124
Hi

can you post some code?
I bet your problem is more of a conversion than of anything else.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Mike9900" <Mi******@discussions.microsoft.comwrote in message
news:2B**********************************@microsof t.com...
Hello,

I am getting SqlDateTime overflow if I use .NET remoting on Windows XP and
Windows XP is the server where the SQL server is located at. If my
computer
is Windows 2003 where the sql server is running and I use client as the
windows XP I do not get this error.
--
Mike

Sep 26 '06 #2
Unfortunately it is not possible to post the code because it is a big
application, but I can say what is going on.

My app is an entrprise application which is made of the following parts:

Layers on the server part:

Data layer: which connects to sql server
Business Rules layer
Facade

Layers on the client:
UI and the interfaces

Also Common system is in both parts.

I can use the application using .NET Remoting in Client/Server or in without
any server. If used without .NET Remoting, everything is fine in any
platform and there is no error when I wirting any data.

But when I use .NET remoting I get the specified error. And this error is
happening only in windows XP. I could be wrong, because win 2003 is my
production OS and there could be some settings and so if it is fresh it could
happen there as well. But I am sure it is from the .NET Remoting. But the
weird part is that it happens after the serialization is done and it is not
from the serilization.

thanks

--
Mike
"Ignacio Machin ( .NET/ C# MVP )" wrote:
Hi

can you post some code?
I bet your problem is more of a conversion than of anything else.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Mike9900" <Mi******@discussions.microsoft.comwrote in message
news:2B**********************************@microsof t.com...
Hello,

I am getting SqlDateTime overflow if I use .NET remoting on Windows XP and
Windows XP is the server where the SQL server is located at. If my
computer
is Windows 2003 where the sql server is running and I use client as the
windows XP I do not get this error.
--
Mike


Sep 26 '06 #3
Found the Error!

If you set the Serialization type to Binary on DataSet, it does not seralize
it correctly on windows xp.
--
Mike
"Ignacio Machin ( .NET/ C# MVP )" wrote:
Hi

can you post some code?
I bet your problem is more of a conversion than of anything else.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Mike9900" <Mi******@discussions.microsoft.comwrote in message
news:2B**********************************@microsof t.com...
Hello,

I am getting SqlDateTime overflow if I use .NET remoting on Windows XP and
Windows XP is the server where the SQL server is located at. If my
computer
is Windows 2003 where the sql server is running and I use client as the
windows XP I do not get this error.
--
Mike


Sep 26 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
7952
by: FrodoBaggins | last post by:
Dear Team, Attempting to insert a record into a SQL database, using the command: command.ExcuteNonQuery(); Get the following error message in the event log: SQLDateTime overflow. Must be...
0
2158
by: Marco Segurini | last post by:
Hi, I am trying to dynamically install/deinstall a message handler to a System.Windows.Forms.Form using NativeWindow. I do not use IMessageFilter derived class because it intercept only the...
1
1362
by: poppy | last post by:
I set up my parameters in code as follows : lTTState.startDate = Today.AddDays(-10) lTTState.startDate = Today lSqlCmd.Parameters.Add(New SqlParameter("@startDate", SqlDbType.DateTime))...
1
2042
by: Paperback Writer | last post by:
I need to insert null in a DateTime field and in the ASP.Net i got this error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. How to accomplish that ?...
0
919
by: uto | last post by:
my development environment consist of web, app server and db server i'd like to call db using remoting and window service. can i call db data in webpage using remoting and windows service?
1
3926
by: lairpr | last post by:
I am having this kind of error when trying to insert a null value; SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. bellow is my code, thanks protected...
3
1740
by: baburk | last post by:
HI I want to pass null or "" When I pass like that I got an error System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59...
4
3912
by: jhansi xavier | last post by:
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
1
2023
by: dougancil | last post by:
I have the following web page: mports System.Data.SqlClient Imports System.Data Partial Class Default2 Inherits System.Web.UI.Page Dim opnumber As String Dim exceptiondate As...
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7110
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7314
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7030
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7482
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5041
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
758
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.