ODBC Data source name not found, and no default driver specified












0















(Environment is Linux CentOs7)



I'm fiddling with odbc.ini file and testing the connection each time I make a change:



isql -v gdHive
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


Within odbc.ini file I've been trying different variations of the description name value pair. This originally was set to:



# Description: DSN Description.
Description=Hortonworks Hive ODBC Driver (64-bit) DSN


I tried changing this to



Description=gdHive


This did not change anything wrt the error I pasted above.



Here's the whole config, it's my first time setting this up so I'm not sure what I've missed:



# HS2 service discovery with ZooKeeper (ServiceDiscoveryMode=1).
ZKNamespace=/hive/hiveserver2

# Set to 1 if you are connecting to Hive Server 1. Set to 2 if you are connecting to Hive Server 2.
HiveServerType=2

# The authentication mechanism to use for the connection.
# Set to 0 for No Authentication
# Set to 1 for Kerberos
# Set to 2 for User Name
# Set to 3 for User Name and Password
# Note only No Authentication is supported when connecting to Hive Server 1.
AuthMech=1

# The Thrift transport to use for the connection.
# Set to 0 for Binary
# Set to 1 for SASL
# Set to 2 for HTTP
# Note for Hive Server 1 only Binary can be used.
ThriftTransport=1

# When this option is enabled (1), the driver does not transform the queries emitted by an
# application, so the native query is used.
# When this option is disabled (0), the driver transforms the queries emitted by an application and
# converts them into an equivalent from in HiveQL.
UseNativeQuery=0

# Set the UID with the user name to use to access Hive when using AuthMech 2 to 8.
UID=

# The following is settings used when using Kerberos authentication (AuthMech 1 and 10)

# The fully qualified host name part of the of the Hive Server 2 Kerberos service principal.
# For example if the service principal name of you Hive Server 2 is:
# hive/myhs2.mydomain.com@EXAMPLE.COM
# Then set KrbHostFQDN to myhs2.mydomain.com
KrbHostFQDN=hive.hadoop.p3.int.example.com

# The service name part of the of the Hive Server 2 Kerberos service principal.
# For example if the service principal name of you Hive Server 2 is:
# hive/myhs2.mydomain.com@EXAMPLE.COM
# Then set KrbServiceName to hive
KrbServiceName=hive

# The realm part of the of the Hive Server 2 Kerberos service principal.
# For example if the service principal name of you Hive Server 2 is:
# hive/myhs2.mydomain.com@EXAMPLE.COM
# Then set KrbRealm to EXAMPLE.COM
KrbRealm=HADOOP.PROD.INT.EXAMPLE.COM

# Set to 1 to enable SSL. Set to 0 to disable.
SSL=0

# Set to 1 to enable two-way SSL. Set to 0 to disable. You must enable SSL in order to
# use two-way SSL.
TwoWaySSL=0

# The file containing the client certificate in PEM format. This is required when using two-way SSL.
ClientCert=

# The client private key. This is used for two-way SSL authentication.
ClientPrivateKey=

# The password for the client private key. Password is only required for password protected
# client private key.
ClientPrivateKeyPassword=


The error message only says "Data source name not found, and no default driver specified". I'm not sure how to set this data source name or choose default driver?










share|improve this question



























    0















    (Environment is Linux CentOs7)



    I'm fiddling with odbc.ini file and testing the connection each time I make a change:



    isql -v gdHive
    [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
    [ISQL]ERROR: Could not SQLConnect


    Within odbc.ini file I've been trying different variations of the description name value pair. This originally was set to:



    # Description: DSN Description.
    Description=Hortonworks Hive ODBC Driver (64-bit) DSN


    I tried changing this to



    Description=gdHive


    This did not change anything wrt the error I pasted above.



    Here's the whole config, it's my first time setting this up so I'm not sure what I've missed:



    # HS2 service discovery with ZooKeeper (ServiceDiscoveryMode=1).
    ZKNamespace=/hive/hiveserver2

    # Set to 1 if you are connecting to Hive Server 1. Set to 2 if you are connecting to Hive Server 2.
    HiveServerType=2

    # The authentication mechanism to use for the connection.
    # Set to 0 for No Authentication
    # Set to 1 for Kerberos
    # Set to 2 for User Name
    # Set to 3 for User Name and Password
    # Note only No Authentication is supported when connecting to Hive Server 1.
    AuthMech=1

    # The Thrift transport to use for the connection.
    # Set to 0 for Binary
    # Set to 1 for SASL
    # Set to 2 for HTTP
    # Note for Hive Server 1 only Binary can be used.
    ThriftTransport=1

    # When this option is enabled (1), the driver does not transform the queries emitted by an
    # application, so the native query is used.
    # When this option is disabled (0), the driver transforms the queries emitted by an application and
    # converts them into an equivalent from in HiveQL.
    UseNativeQuery=0

    # Set the UID with the user name to use to access Hive when using AuthMech 2 to 8.
    UID=

    # The following is settings used when using Kerberos authentication (AuthMech 1 and 10)

    # The fully qualified host name part of the of the Hive Server 2 Kerberos service principal.
    # For example if the service principal name of you Hive Server 2 is:
    # hive/myhs2.mydomain.com@EXAMPLE.COM
    # Then set KrbHostFQDN to myhs2.mydomain.com
    KrbHostFQDN=hive.hadoop.p3.int.example.com

    # The service name part of the of the Hive Server 2 Kerberos service principal.
    # For example if the service principal name of you Hive Server 2 is:
    # hive/myhs2.mydomain.com@EXAMPLE.COM
    # Then set KrbServiceName to hive
    KrbServiceName=hive

    # The realm part of the of the Hive Server 2 Kerberos service principal.
    # For example if the service principal name of you Hive Server 2 is:
    # hive/myhs2.mydomain.com@EXAMPLE.COM
    # Then set KrbRealm to EXAMPLE.COM
    KrbRealm=HADOOP.PROD.INT.EXAMPLE.COM

    # Set to 1 to enable SSL. Set to 0 to disable.
    SSL=0

    # Set to 1 to enable two-way SSL. Set to 0 to disable. You must enable SSL in order to
    # use two-way SSL.
    TwoWaySSL=0

    # The file containing the client certificate in PEM format. This is required when using two-way SSL.
    ClientCert=

    # The client private key. This is used for two-way SSL authentication.
    ClientPrivateKey=

    # The password for the client private key. Password is only required for password protected
    # client private key.
    ClientPrivateKeyPassword=


    The error message only says "Data source name not found, and no default driver specified". I'm not sure how to set this data source name or choose default driver?










    share|improve this question

























      0












      0








      0








      (Environment is Linux CentOs7)



      I'm fiddling with odbc.ini file and testing the connection each time I make a change:



      isql -v gdHive
      [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
      [ISQL]ERROR: Could not SQLConnect


      Within odbc.ini file I've been trying different variations of the description name value pair. This originally was set to:



      # Description: DSN Description.
      Description=Hortonworks Hive ODBC Driver (64-bit) DSN


      I tried changing this to



      Description=gdHive


      This did not change anything wrt the error I pasted above.



      Here's the whole config, it's my first time setting this up so I'm not sure what I've missed:



      # HS2 service discovery with ZooKeeper (ServiceDiscoveryMode=1).
      ZKNamespace=/hive/hiveserver2

      # Set to 1 if you are connecting to Hive Server 1. Set to 2 if you are connecting to Hive Server 2.
      HiveServerType=2

      # The authentication mechanism to use for the connection.
      # Set to 0 for No Authentication
      # Set to 1 for Kerberos
      # Set to 2 for User Name
      # Set to 3 for User Name and Password
      # Note only No Authentication is supported when connecting to Hive Server 1.
      AuthMech=1

      # The Thrift transport to use for the connection.
      # Set to 0 for Binary
      # Set to 1 for SASL
      # Set to 2 for HTTP
      # Note for Hive Server 1 only Binary can be used.
      ThriftTransport=1

      # When this option is enabled (1), the driver does not transform the queries emitted by an
      # application, so the native query is used.
      # When this option is disabled (0), the driver transforms the queries emitted by an application and
      # converts them into an equivalent from in HiveQL.
      UseNativeQuery=0

      # Set the UID with the user name to use to access Hive when using AuthMech 2 to 8.
      UID=

      # The following is settings used when using Kerberos authentication (AuthMech 1 and 10)

      # The fully qualified host name part of the of the Hive Server 2 Kerberos service principal.
      # For example if the service principal name of you Hive Server 2 is:
      # hive/myhs2.mydomain.com@EXAMPLE.COM
      # Then set KrbHostFQDN to myhs2.mydomain.com
      KrbHostFQDN=hive.hadoop.p3.int.example.com

      # The service name part of the of the Hive Server 2 Kerberos service principal.
      # For example if the service principal name of you Hive Server 2 is:
      # hive/myhs2.mydomain.com@EXAMPLE.COM
      # Then set KrbServiceName to hive
      KrbServiceName=hive

      # The realm part of the of the Hive Server 2 Kerberos service principal.
      # For example if the service principal name of you Hive Server 2 is:
      # hive/myhs2.mydomain.com@EXAMPLE.COM
      # Then set KrbRealm to EXAMPLE.COM
      KrbRealm=HADOOP.PROD.INT.EXAMPLE.COM

      # Set to 1 to enable SSL. Set to 0 to disable.
      SSL=0

      # Set to 1 to enable two-way SSL. Set to 0 to disable. You must enable SSL in order to
      # use two-way SSL.
      TwoWaySSL=0

      # The file containing the client certificate in PEM format. This is required when using two-way SSL.
      ClientCert=

      # The client private key. This is used for two-way SSL authentication.
      ClientPrivateKey=

      # The password for the client private key. Password is only required for password protected
      # client private key.
      ClientPrivateKeyPassword=


      The error message only says "Data source name not found, and no default driver specified". I'm not sure how to set this data source name or choose default driver?










      share|improve this question














      (Environment is Linux CentOs7)



      I'm fiddling with odbc.ini file and testing the connection each time I make a change:



      isql -v gdHive
      [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
      [ISQL]ERROR: Could not SQLConnect


      Within odbc.ini file I've been trying different variations of the description name value pair. This originally was set to:



      # Description: DSN Description.
      Description=Hortonworks Hive ODBC Driver (64-bit) DSN


      I tried changing this to



      Description=gdHive


      This did not change anything wrt the error I pasted above.



      Here's the whole config, it's my first time setting this up so I'm not sure what I've missed:



      # HS2 service discovery with ZooKeeper (ServiceDiscoveryMode=1).
      ZKNamespace=/hive/hiveserver2

      # Set to 1 if you are connecting to Hive Server 1. Set to 2 if you are connecting to Hive Server 2.
      HiveServerType=2

      # The authentication mechanism to use for the connection.
      # Set to 0 for No Authentication
      # Set to 1 for Kerberos
      # Set to 2 for User Name
      # Set to 3 for User Name and Password
      # Note only No Authentication is supported when connecting to Hive Server 1.
      AuthMech=1

      # The Thrift transport to use for the connection.
      # Set to 0 for Binary
      # Set to 1 for SASL
      # Set to 2 for HTTP
      # Note for Hive Server 1 only Binary can be used.
      ThriftTransport=1

      # When this option is enabled (1), the driver does not transform the queries emitted by an
      # application, so the native query is used.
      # When this option is disabled (0), the driver transforms the queries emitted by an application and
      # converts them into an equivalent from in HiveQL.
      UseNativeQuery=0

      # Set the UID with the user name to use to access Hive when using AuthMech 2 to 8.
      UID=

      # The following is settings used when using Kerberos authentication (AuthMech 1 and 10)

      # The fully qualified host name part of the of the Hive Server 2 Kerberos service principal.
      # For example if the service principal name of you Hive Server 2 is:
      # hive/myhs2.mydomain.com@EXAMPLE.COM
      # Then set KrbHostFQDN to myhs2.mydomain.com
      KrbHostFQDN=hive.hadoop.p3.int.example.com

      # The service name part of the of the Hive Server 2 Kerberos service principal.
      # For example if the service principal name of you Hive Server 2 is:
      # hive/myhs2.mydomain.com@EXAMPLE.COM
      # Then set KrbServiceName to hive
      KrbServiceName=hive

      # The realm part of the of the Hive Server 2 Kerberos service principal.
      # For example if the service principal name of you Hive Server 2 is:
      # hive/myhs2.mydomain.com@EXAMPLE.COM
      # Then set KrbRealm to EXAMPLE.COM
      KrbRealm=HADOOP.PROD.INT.EXAMPLE.COM

      # Set to 1 to enable SSL. Set to 0 to disable.
      SSL=0

      # Set to 1 to enable two-way SSL. Set to 0 to disable. You must enable SSL in order to
      # use two-way SSL.
      TwoWaySSL=0

      # The file containing the client certificate in PEM format. This is required when using two-way SSL.
      ClientCert=

      # The client private key. This is used for two-way SSL authentication.
      ClientPrivateKey=

      # The password for the client private key. Password is only required for password protected
      # client private key.
      ClientPrivateKeyPassword=


      The error message only says "Data source name not found, and no default driver specified". I'm not sure how to set this data source name or choose default driver?







      odbc






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 13 '18 at 0:50









      Doug FirDoug Fir

      5,3362783148




      5,3362783148
























          1 Answer
          1






          active

          oldest

          votes


















          0














          The "Description" keyword's value is entirely cosmetic in an ODBC DSN. It has no functional use. You can set it to any arbitrary string.



          ODBC will be very hard to learn by trial-and-error shots in the dark. I suggest you take a look at the official ODBC specification. You might also look at some docs for the Driver Manager in your environment, such as this for iODBC, or this for unixODBC.






          share|improve this answer























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272201%2fodbc-data-source-name-not-found-and-no-default-driver-specified%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            The "Description" keyword's value is entirely cosmetic in an ODBC DSN. It has no functional use. You can set it to any arbitrary string.



            ODBC will be very hard to learn by trial-and-error shots in the dark. I suggest you take a look at the official ODBC specification. You might also look at some docs for the Driver Manager in your environment, such as this for iODBC, or this for unixODBC.






            share|improve this answer




























              0














              The "Description" keyword's value is entirely cosmetic in an ODBC DSN. It has no functional use. You can set it to any arbitrary string.



              ODBC will be very hard to learn by trial-and-error shots in the dark. I suggest you take a look at the official ODBC specification. You might also look at some docs for the Driver Manager in your environment, such as this for iODBC, or this for unixODBC.






              share|improve this answer


























                0












                0








                0







                The "Description" keyword's value is entirely cosmetic in an ODBC DSN. It has no functional use. You can set it to any arbitrary string.



                ODBC will be very hard to learn by trial-and-error shots in the dark. I suggest you take a look at the official ODBC specification. You might also look at some docs for the Driver Manager in your environment, such as this for iODBC, or this for unixODBC.






                share|improve this answer













                The "Description" keyword's value is entirely cosmetic in an ODBC DSN. It has no functional use. You can set it to any arbitrary string.



                ODBC will be very hard to learn by trial-and-error shots in the dark. I suggest you take a look at the official ODBC specification. You might also look at some docs for the Driver Manager in your environment, such as this for iODBC, or this for unixODBC.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 19 '18 at 20:23









                TallTedTallTed

                6,07021427




                6,07021427






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53272201%2fodbc-data-source-name-not-found-and-no-default-driver-specified%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Florida Star v. B. J. F.

                    Danny Elfman

                    Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues