2
Answers

Create DSN using C#

Pradeep Yadav

Pradeep Yadav
5y
2k
1
Hi Team,
 
I am creting DSN for Hive driver using C#, we are able to create using below code
  1. var driverKey = Microsoft.Win32.Registry.LocalMachine.CreateSubKey(ODBCINST_INI_REG_PATH + driverName);  
  2. if (driverKey == null) throw new Exception(string.Format("ODBC Registry key for driver '{0}' does not exist", driverName));  
  3. string driverPath = driverKey.GetValue("Driver").ToString();  
  4. var datasourcesKey = Microsoft.Win32.Registry.LocalMachine.CreateSubKey(ODBC_INI_REG_PATH + "ODBC Data Sources");  
  5. if (datasourcesKey == null) throw new Exception("ODBC Registry key for datasources does not exist");  
  6. datasourcesKey.SetValue(dsnName, driverName);  
  7. var dsnKey = Microsoft.Win32.Registry.LocalMachine.CreateSubKey(ODBC_INI_REG_PATH + dsnName);  
  8. if (dsnKey == null) throw new Exception("ODBC Registry key for DSN was not created");  
  9. dsnKey.SetValue("Database", database);  
  10. dsnKey.SetValue("Description", description);  
  11. dsnKey.SetValue("Driver", driverPath);  
  12. dsnKey.SetValue("LastUser", Environment.UserName);  
  13. dsnKey.SetValue("Server", server);  
  14. dsnKey.SetValue("Database", database);  
  15. dsnKey.SetValue("AuthMech", "3");  
  16. dsnKey.SetValue("UID", "mapr");  
  17. dsnKey.SetValue("PWD", "mapr");  
However I want to set server side properties available in Advance options button by adding key and value. 
 
I tried using below code 
  1. dsnKey.SetValue("hive.vectorized.execution.enabled", "1");  
  2. dsnKey.SetValue("hive.vectorized.execution.reduce.enabled", "1");
However, it is not working. 
 
Please help  me for the same
Answers (2)
Next Recommended Forum