Some vaguely structured thoughts on the differences that you see between SQL as implemented by one DBMS and that of another.
Have you received the following error:
Error Type:
OraOLEDB (0x80040E4B)
Accessor is not a parameter accessor.
This is from an ASP application running against an Oracle database. Here is how I fixed this problem in my application:
The problem was due to excessive digits in a number being returned by an Oracle SQL SELECT statement. To fix it, I changed the SQL statement so that it used the Oracle ROUND function to remove some of those digits, e.g.:
change:
SELECT fees / days
FROM timesheet
to:
SELECT ROUND(fees / days, 3)
FROM timesheet