Devart Forums

Hello Forum,
I have a MSSQL Database and I use UNIDac, last Version at this time.
In the tables I have different Kind of fields such as Date Time and DateTime.
I never changed the Standard Options of the TUniConnection, so I have OLEDBProvider set to prAuto. Everything works fine, but on same Computers I have to install the Native Client, otherwise it doesn't work properly.
So I forced the OLEDBProvider to prDirect, to get rid of the Native Client.
Now I get the EXCEPTION "DateTime type 40" in both DesignTime and Runtime.
What should I care for on Setting the Option to prDirect? Is there a list of limitations?
Many Thanks in Advance,
Francesco

We have reproduced the 'DateTime type 40' error message for the described case. We will investigate this behavior and inform you about the results.

A similar thing is my case:

I just installed version 6.0.2 and changed nothing, just installed the new version...now I get the same exception ("...datetime type 40...").

I had to install 6.0.1 back then, everything went back to "normal"

I hope this is fixed soon, I trust Devart support very much!

Thank you in advanced...

I changed my DATE fields to DATETIME and now everything works fine!

Also

Changing/Casting DATE values to DATETIME solves (mean while...)

hehe

We have fixed the error 'DateTime type 40'. This fix will be included in the next UniDAC build.