NandiniN
Databricks Employee
Databricks Employee

 

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