Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Data Services 4.1 - SQL Server Native Client issue

Former Member
‎06-14-2013 5:39 PM

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

45804460DBS-07040114/06/2013 17:19|Data flow DF_XXXX|Loader Query_XXXX
45804460DBS-07040114/06/2013 17:19ODBC 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.

1 Comment
Labels in this area
Popular Blog Posts