[gdal-dev] MSSQL Driver and Bulk Copy Drivers

[Seth G]

Hi all,

>From the Microsoft docs at https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver16:

> The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward.

So the native SQL Server driver will be retired, however the GDAL MSSQL Driver only supports bulk copy (BCP) with this driver and not the "ODBC Driver 17 for SQL Server" - the following error is returned:

> ERROR 1: SQL Error SQLState=HY000, NativeError=0, Msg=[Microsoft][ODBC Driver 17 for SQL Server]Connection is not enabled for BCP

According to https://learn.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server?view=sql-server-ver16:

> The ODBC driver comes with tools such as sqlcmd and bcp.

Does anyone know if BCP can be enabled with the MS ODBC drivers?

Thanks,

Seth



--
web:https://geographika.net
twitter: @geographika