Range Check Error

[carlonarcisi]

DelphiXe2
UniDAC LAST night version 6.2.8 beta 20/nov/2015

When i try to connect to MSSQL 2005 SP3 (version 9.0.4035) in DIRECTMODE is raised error "Range Check Error"

with MSSQL 2008R2 V.10.50.4042 all is ok

thanks
carlo

[FredS]

Ran into a Range Check Error myself using Overnight Snapshot source against an Azure SQL DB yesterday.

Opened up msprovider230.dproj and copied its settings into DAC.inc, turns out it should be compiled with Range Checking Off. That fixed the error and another one I was chasing as well.. hope that helps..

Added to top of DAC.Inc:

Code: Select all

{$ALIGN 8}
{$ASSERTIONS ON}
{$BOOLEVAL OFF}
{$EXTENDEDSYNTAX ON}
{$IMPORTEDDATA ON}
{$IOCHECKS ON}
{$LOCALSYMBOLS OFF}
{$LONGSTRINGS ON}
{$OPENSTRINGS ON}
{$OPTIMIZATION ON}
{$OVERFLOWCHECKS OFF}
{$RANGECHECKS OFF}
{$REFERENCEINFO OFF}
{$SAFEDIVIDE OFF}
{$STACKFRAMES OFF}
{$TYPEDADDRESS OFF}
{$VARSTRINGCHECKS ON}
{$WRITEABLECONST ON}
{$MINENUMSIZE 1}

[carlonarcisi]

Hi Fred ! thank you for the tips!
I made the changes you suggested and it works, even if, changing compilation parameters not seem the solution
I hope Devart 's guys will fix as soon as possible.
bye !
thanks a lot
Carlo

[azyk]

Unfortunately, we can't reproduce "Range Check Error" in the described case. Could you send test credentials to andreyz*devart*com for connection to your SQL Server, in order for us to be able to reproduce the described issue?