Django-pyodbc SQL Server/freetds server connection problems on linux

Posted by wizard on Stack Overflow See other posts from Stack Overflow or by wizard
Published on 2010-05-07T21:20:46Z Indexed on 2010/05/30 19:22 UTC
Read the original article Hit count: 577

Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnectW)')

I'm migrating from developing on a windows development machine to Linux machine in production and I'm having issues with the freetds driver. As far as I can tell that error message means it can't find the driver. I can connect via the cli via sqsh and tsql. I've setup my settings.py as such.

   'bc2db': {
        'ENGINE': 'sql_server.pyodbc',
        'NAME': 'DataTEST',
        'USER': 'appuser',
        'PASSWORD': 'PASS',
        'HOST': 'bc2.domain.com',
        'options': {
            'driver': 'FreeTDS',
            }
    },

Does anyone have any SQL Server experience with django? do I have to use a dns? (how would I format that?)

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about django