Error Number -2147352566 Out Of Present Range
You cannot post EmotIcons. ADO recordset)? Go to Solution 2 3 Participants Delphiwizard(2 comments) TempDBA LVL 25 MS SQL Server 200818 celazkon LVL 7 MS SQL Server 20081 4 Comments LVL 7 Overall: Level 7 MS Feel free to ask any further questions and I'll help if I can.
ADO recordset)? The time now is 06:48 PM. To resolve this, change the destination data type to something larger.
the value i had in there was some like 53435534126262 , immediately changed it to a text field and the problem disappeared try that?? Suggested Solutions Title # Comments Views Activity Macro to create Bar charts 4 54 53d Excel - Save a copy of work book 13 74 24d VBA filters 2 33 34d or has the VBScript tirned these into datetime variables? Does it have its code (such as ORA-00942)?
Why does using the low range of a 4WD transmission give better acceleration? If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? So why am I still getting an "out of present range" error? Proton - neutron fusion?
Try using a datatype that supports huge values if it' s a numeric column. I use vb to execute the query and return the error message, no error number in front. This had the added benefit of appearing to enable connection pooling when it previously didn't appear to have been working. MS Excel Visual Basic Classic Executing a Windows API Function from Access Video by: TechMommy As developers, we are not limited to the functions provided by the VBA language.
You cannot post HTML code. I hope this helps someone, as it was an incredibly frustrating 3 weeks that I spent tracking down this problem. You cannot rate topics. Who/What is "Concerned Citizen" in The Witcher 3?
Privacy statement © 2016 Microsoft. When the problem reoccurred, I restarted IIS on the machine at that point that was showing the error (the situation is often that it is only occurring on one of the So the date range your DB can accept has been exceeded by the value that you added to Go to Solution 2 +1 4 Participants jimyX(2 comments) LVL 24 Delphi21 MS my review here All rights reserved.
ASP to database is done via a DSN using SQL Server Client 10 drivers. Share it with others Like this thread? No error message also.
Please support animal rights.
Promoted by Recorded Future Enhance your security with threat intelligence from the web. I'll update my original question with some more info now, I've marked you as correct as I'm sure this needed doing any way (I hope this is right to do). –Eric Obviously this then errors when you try and assign a string to a CURRENCY. You cannot send emails.
If you want to do the checking in ASP, let us knoe what you are trying to do... Firstly I changed the database authentication method to SQL instead of Windows based. I would try: if not isdate(SPEnews__startdate) then SPEnews__startdate= (#1900-01-01#) Select all Open in new window or: if not isdate(SPEnews__startdate) then SPEnews__startdate= DateValue("1900-01-01") Select all Open in new window 0 Message There are two instances of IIS, independent of each other, they both talk to a single database whether it be local at the time or not, they both execute identical sync'd
One side effect of changing to the driver is that the stored procedures and ASP became susceptible to intermediate results being returned from the stored procedure if there were multiple statements Is this a bug?