SQLBulkOperations with SQL_ADD not supported by SQL Server ODBC Driver 1.0 for Linux

Question

Hello,

I am attempting to port my application from Windows to use Linux and the SQL Server ODBC Driver for Linux.  I have code that performs cursor row insertions using SQLBulkOperations with the SQL_ADD argument (as documented here Inserting Rows with SQLBulkOperations)

I am seeing the following error message returned from the driver:

[unixODBC][Driver Manager]Driver does not support this function

Is this a known limitation of the SQL Server ODBC Driver 1.0?  I don't see anything in the documentation for the driver that suggests this limitation. 

Thank you for any help anyone can provide.

Dave

---

David Ritter

Answer 1

[unixODBC][Driver Manager]Driver does not support this function

I think it is better to use another way like SSIS to insert the data in SQL Server, since this error message indicate this driver not support this function