Skip to Content

Common Solution for 'SqlDataSource' to work on SQL Server and SAP HANA

Dec 14, 2016 at 11:55 AM


avatar image
Former Member


We are using the asp 'SqlDataSource' control to populate the 'drop downs' in 'GridDropDownColumn' in our application. However we are making changes in our application to provide support to SAP HANA database along with SQL server.

The 'SqlDataSource' control does not work with SAP HANA.

Since we have more than 1000 grids in our application, Is there a generic way to make the control work for both databases with minimum change and without having to use template column or additional grid event?


10 |10000 characters needed characters left characters exceeded

What exactly does not work? Do you get any error messages? From the web page I take it that the control works with ODBC data sources in general - so that should be possible with HANA, too.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

David Zapata Oct 11, 2017 at 10:56 PM

I have the same need, could you tell me how you solved the problem?

10 |10000 characters needed characters left characters exceeded