Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2024 09:00 AM
Hello @_Sumit_Kate
Not all databases support variable declaration in the same way. It is possible System.Data.Odbc does not support it, in Databricks we use Simba ODBC drivers. But I would say let's check the official document too - https://learn.microsoft.com/en-us/dotnet/api/system.data.odbc.odbcconnection.getschema
Just try adding the below config(s) to the connection string and see if it helps
-
EnableNativeParameterizedQuery=1 -
UseNativeQuery=2