Haven’t tried on CentOS, but have you checked the latest documentation? http://drill.apache.org/docs/configuring-connections-on-linux-and-mac-os-x/
On OSX I found that the odbc.ini file in the user home directory controls the user DSN and the odic.ini in the /Library/ODBC/odbc.ini controls the system DSN. Here is a sample odbc.ini file (I found it easier to edit the file vs using the iODBC admin tool). The last entry is for 0.9 + when Authentication is enabled for Drill. [ODBC Data Sources] Drill Direct = MapR Drill ODBC Driver Drill Zookeeper = MapR Drill ODBC Driver Drill Secure = MapR Drill ODBC Driver [Drill Direct] Driver = /opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib ConnectionType = Direct HOST = maprdemo PORT = 31010 Catalog = DRILL AdvanacedProperties = CastAnyToVarchar=true;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,INFORMATION_SCHEMA;NumberOfPrefetchBuffers=5; [Drill Zookeeper] Driver = /opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib ConnectionType = Zookeeper HOST = [HOST] PORT = [PORT] ZKQuorum = maprdemo:5181 ZKClusterID = demo_mapr_com-drillbits Catalog = DRILL AdvanacedProperties = CastAnyToVarchar=true;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,INFORMATION_SCHEMA;NumberOfPrefetchBuffers=5; [Drill Secure] Driver = /opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib ConnectionType = Zookeeper HOST = [HOST] PORT = [PORT] ZKQuorum = drill-test:5181 ZKClusterID = drill-test-drillbits Catalog = DRILL AuthenticationType = Basic Authentication AdvanacedProperties = CastAnyToVarchar=true;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,INFORMATION_SCHEMA;NumberOfPrefetchBuffers=5; Maybe these pointers will be helpful to track down your issue. —Andries On May 12, 2015, at 5:23 AM, mohit.kaushik <[email protected]> wrote: > > I am trying to configure the Drill ODBC driver on centos. I have installed > the iodbc driver manager "libiodbc-3.52.10" and the Drill driver > "MapRDrillODBC-0.09.0.x86_64.rpm" and I am using the > Driver=/opt/mapr/drillodbc/lib/64/libmaprdrillodbc64.so. my zkClusterId is > correct. I have checked everything many times but haveing problem while > trying to test connection with "iodbctest" > > 1: SQLDriverConnect = [iODBC][Driver Manager]Sample MapR Drill DSN 64: cannot > open shared object file: No such file or directory (0) SQLSTATE=00000 > 2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be > loaded (0) SQLSTATE=IM003 > > The documentation says > [iODBC][Driver Manager]Data source name not found and no default driver > specified. Driver could not be loaded, SQLSTATE=IM002 > > There are several reasons why this message could occur. The best solution is > to trace through what's happening: your application has been linked against > libiodbc, which has tried to find an odbc.ini file one way or another - > either through the ODBCINI environment variable or the fall-back paths > (typically /etc/odbc.ini, depending on how it was compiled). You should check > that such a file exists in a suitable location, and that it is accessible > (particularly if your application runs with different user privileges - such > as apache/php running as a www-data user). > > Additionally, it could be that iODBC has found a suitable odbc.ini file, but > none of the file(s) found contain the DSN you've requested. Check the syntax > of your request - is the ODBC connect-string correct, and does the DSN you're > requesting exist? See also the section of this FAQ, above, entitled `What's > an odbc.ini and what do I put in it?'. > I see no permission issues, file is present and is not corrupt. Any hints? > Regards > Mohit Kaushik > Software Engineer > A Square,Plot No. 278, Udyog Vihar, Phase 2, Gurgaon 122016, India > Tel: +91 (124) 4969352 | Fax: +91 (124) 4033553 > > <Mail Attachment.jpeg>interactive social intelligence at work... > > <Mail Attachment.png> <Mail Attachment.png> <Mail Attachment.png> <Mail > Attachment.png> <Mail Attachment.bmp> > <graphics1.jpeg> ... ensuring Assurance in complexity and uncertainty > > This message including the attachments, if any, is a confidential business > communication. If you are not the intended recipient it may be unlawful for > you to read, copy, distribute, disclose or otherwise use the information in > this e-mail. If you have received it in error or are not the intended > recipient, please destroy it and notify the sender immediately. Thank you > > >
