User Profile

JayS555

Copper Contributor

Joined 3 months ago

3 Posts

View All Badges

User Widgets

Recent Discussions

Re: ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for...
Thanks George. It was really an error on the where clause portion of the sql stmt.Once that was corrected, I was able to update successfully.
Oct 31, 2024 Place Access
41Views
0likes
0Comments
Re: ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for...
Thanks Ken. Also tried that but I when I realized that my mistake was really in the where clause. I was using a boolean field with a between operator using date values. Once that was corrected, error no more.
Oct 31, 2024 Place Access
42Views
0likes
0Comments
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for...
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for SQL_BIT to SQL_TYPE_DATE. (#40190) I'm trying to execute an update statement in MS Access using the following, but keep getting an error message: Any ideas what I'm doing wrong here? Appreciate any feedback.
Solved
Oct 29, 2024 Place Access
MS Access ODBC --call failed
153Views
0likes
6Comments

Groups

Recent Blog Articles

No content to show