pyodbc connect string

[Chris Angelico]

On Wed, Apr 30, 2014 at 10:57 AM, Larry Martell <larry.martell at gmail.com> wrote:
> This works:
>
> pyodbc.connect('DRIVER=FreeTDS;' 'SERVER=xx.xx.xx.xx;' 'PORT=1433;'
> 'DATABASE=blah;' 'UID=foo;' 'PWD=bar;')
>
> But this does not:
>
> pyodbc.connect(conn_str)
>
> conn_str is constructed with:
>
>  conn_str = "'DRIVER=%s;' 'SERVER=%s;' 'PORT=%s;' 'DATABASE=%s;'
> 'UID=%s;' 'PWD=%s;'" \
>                 % (RECIPE_DB['DRIVER'], RECIPE_DB['SERVER'],
> RECIPE_DB['PORT'], RECIPE_DB['DATABASE'],
>                    RECIPE_DB['USER'], RECIPE_DB['PASSWORD'])
>
> Anyone have any ideas as to why this doesn't work.

Start by printing out conn_str. That'll tell you if it's actually
coming out the way you think it is. I can see where the problem
probably is (assuming these are faithful copy/pastes), in the form of
an extra double quote; but actually print them out and see what you're
getting.

ChrisA