Skip to Content
Author's profile photo Former Member

SAP Data Services 4.1 – SQL Server Native Client issue

I ran into this problem today after creating a dataflow which wrote data to a temporary table.

4580 4460 DBS-070401 14/06/2013 17:19 |Data flow DF_XXXX|Loader Query_XXXX
4580 4460 DBS-070401 14/06/2013 17:19 ODBC data source <SQLSERVER\INSTANCE> error message for operation <SQLBindParameter>: <[Microsoft][ODBC SQL Server Driver]Optional feature not implemented>.

The issue:

The temporary table had a date datatype on it and kept returning the following error when trying to create the table in the SQL Server 2008 R2 SP2 database.

Why this issue:

I did not have the latest version of SQL Server Native client installed. In my case above on my Win 2008 R2 server I only had the default one installed (SQL Server 6.01.7601.17514 SQLSRV32.DLL) which I think is pre-2008 and pre-2008 SQL Servers did not have a date data type.

So I did this:

Downloaded the x64 version of Microsoft® SQL Server® 2012 Native Client [sqlncli] which can be found here. Installed this and then problem solved even though I use SQL Server 2008 R2.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Blog Post Author