pcsoft.us.windevCopyright 2026, PC SOFT31 Jan 2018 12:19:00 Z30 Jan 2018 10:17:00 ZHi, I have a strange isssue and can't get my fingers on it. I have micrsoft sql server holding a database with some info. Using sql-manager I can see all info is okay. When I open a connection from Windev using the OLEDB driver, all dates are treated like full strings so instead of getting 20180130 I'm getting "2018-01-" as a result which is of course a bad date. And the app is throwing all kind of errors. When using the native sql driver from pcsoft I have no issue at all?!?! Even when using hfsql control centre to connect to the sqlserver it shows the right info. Is there some setting I overlooked of what?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64327/read.awp31 Jan 2018 12:19:00 ZBe carefull with the sqlserver version and sqlncli version. The date and time types are only valid for sqlserver >=2008 If y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64327/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64327/read.awpwd22 - sqlserver errorguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64324/read.awp31 Jan 2018 10:49:00 ZThere is definitely a difference when creating table using the regular OLEDBSQL driver compared to the native driver Let's sa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64324/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64324/read.awpwd22 - sqlserver errorguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64322/read.awp31 Jan 2018 10:22:00 ZI also have a local sqlexpress database running without problems. Comparing this one with it's 'big brother' I now see that some…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64322/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64322/read.awpwd22 - sqlserver errorguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64308/read.awp30 Jan 2018 14:51:00 ZWhen I switch from hOledbSQLServer (which is actually SQLOLEDB) to SQLNCLI11 it also works flawless. Must be something on by de…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64308/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64308/read.awpwd22 - sqlserver errorguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64307/read.awp30 Jan 2018 14:24:00 ZIt's an Enterprise database and you may try out select getdate() directly from Sqlserver Management Studio, I bet you'll get eg …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64307/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64307/read.awpwd22 - sqlserver errorguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64303/read.awp30 Jan 2018 12:16:00 ZHi Arie, from what you are describing, I would have a look in the settings of the ODBC client... Or maybe the connection stri…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64303/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64291-wd22-sqlserver-error-64303/read.awpwd22 - sqlserver error