Database Reference
In-Depth Information
the strings will be. After you have completed the property settings, click
OK to save the File DSN.
You can use the resulting file to prepare a connection string.
Now, open the file in Notepad, and you will see a series of names and
values in the format Name=value that define the parameter values for the
connection. You can take these name/value pairs and convert them to a
connection string by removing the carriage returns and adding a semicolon
between each name/value pair. So, if the original file looked like this:
[ODBC]
DRIVER=Hortonworks Hive ODBC Driver
Schema=default
Port=10001
HS2AuthMech=2
Host=Your_Hive_Server
HiveServerType=2
DESCRIPTION=Test
ApplySSPWithQueries=1
You should end up with a connection string like this:
DRIVER=Hortonworks Hive ODBC Driver;Schema=default;
Port=10001;HS2AuthMech=2;Host=Your_Hive_Server;
HiveServerType=2;DESCRIPTION=Test;ApplySSPWithQueries=1
NOTE
You may find some names without any specified values in the File DSN.
These are properties that are left at their default settings, and they are
safe to leave out of the connection string. They were left out of this
example for clarity.
Search WWH ::




Custom Search