Exception DateTime type 40 with prDirect

[Fratod68]

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

[azyk]

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

[felixbcastillo]

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...

[felixbcastillo]

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

Also

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

hehe

[azyk]

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