You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There is a problem with generating SQL, since ODBC and OLE DB connections do not support named parameters in INSERT/UPDATE queries.
The parameters need to be replaced with ? symbols in the queries.
millions thanks for this contribution; I will have a look. Nevertheless, I am currently working on a fix for odbc and oledb that can be used exactly in the same way that nativesql (with some manipulation of the query). Therefore, the usage would be more straigth forward, and the switch from a connection type to another doesn't involve any change in the etl process description.
There is a problem with generating SQL, since ODBC and OLE DB connections do not support named parameters in INSERT/UPDATE queries.
The parameters need to be replaced with ? symbols in the queries.
I've raised a sample PR showing a way how this can be remedied. Could we have something like this: https://github.com/paillave/Etl.Net/pull/442/
The text was updated successfully, but these errors were encountered: