Re: Drill authentication with pyodbc

2015-06-09 Thread Christopher Matta
My fault, I had a greedy regular expression that was replacing the space in the value “Basic Authentication” with nothing. It’s working now. Some people, when confronted with a problem, think “I know, I’ll use regular expressions.” Now they have two problems. Thanks guys. Chris

Drill authentication with pyodbc

2015-06-08 Thread Christopher Matta
Does anyone know what the expected key names are for userid and password for an ODBC connection? I was using pyodbc to connect to Drill pre-1.0 but now with authentication enabled I haven’t figured out how to do it. Relevant errors: conn =

Re: Drill authentication with pyodbc

2015-06-08 Thread Christopher Matta
That's actually my notebook, which I'm trying to update to use with Drill authentication, yes I'm using the DSN (the first argument in the connect function). Chris Matta cma...@mapr.com 215-701-3146 On Mon, Jun 8, 2015 at 10:24 PM, Matt bsg...@gmail.com wrote: Does using a DSN as per this

Re: Drill authentication with pyodbc

2015-06-08 Thread Kristine Hahn
Case-sensitive I think, try all caps. On Monday, June 8, 2015, Kristine Hahn kh...@maprtech.com wrote: Set the UID and PWD properties in the connection string. http://tshiran.github.io/drill/docs/odbc-configuration-reference/ has a first draft of the docs that include a description of the