DevForce Community Forum : SQL Server 2008 - SQLCNCLI10 and DateTime Fields http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : SQL Server 2008 - SQLCNCLI10 and DateTime Fields Wed, 10 Jun 2026 10:00:46 -700 Thu, 18 Feb 2010 09:23:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1648 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ SQL Server 2008 - SQLCNCLI10 and DateTime Fields : DevForce Classic does not support... http://www.ideablade.com/forum/forum_posts.asp?TID=1648&PID=6227#6227 Author: davidklitzke
Subject: 1648
Posted: 18-Feb-2010 at 9:23am

DevForce Classic does not support SQL Server 2008 Date and Time data type.  If you want support for SQL Server 2008 Date and Time data type, you will need to use DevForce WinClient, DevForce Silverlight, or DevForce Universal.]]> Thu, 18 Feb 2010 09:23:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1648&PID=6227#6227 SQL Server 2008 - SQLCNCLI10 and DateTime Fields : Hello ! I evaluated DevForce... http://www.ideablade.com/forum/forum_posts.asp?TID=1648&PID=6221#6221 Author: Mike
Subject: 1648
Posted: 18-Feb-2010 at 1:02am

Hello !
 
I evaluated DevForce Classic times ago for building  a DB-Application with SQL Server 2005.
Meanwhile I switched to SQL Server 2008. In order to use also the new Native OleDb driver for SQL server 2008
i replaced SQLNCLI.1 in the connectionstring with SQLNCLI10.
Now the Application works , I can read from the SQL 2008 DB and write to it, with one Exception:
I cannot Insert or Update Entities containing  DateTime Columns. I always get an Exception when callign SaveChanges on
the PersistenceManager.
 
"The fractional part of the provided time value overflows the scale of the corresponding SQL Server parameter or column. Increase bScale in DBPARAMBINDINFO or column scale to correct this error".
 
I went back to the DB an changed the columns to DateTime2(7), recreated my Entities, but still the same Error.
After that I went into the ORM-Tool and had a look at the Simple Properties, and I saw that the DateTime-columns is mapped to System.String at the Source DataType.
 
Now I'm stuck since if found no way way to use SQLNCLI with DevForce Classic.
Can you help me ?
 
Mike
 
 
 
 
]]> Thu, 18 Feb 2010 01:02:56 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1648&PID=6221#6221