Django-pyodbc SQL Server/freetds server connection problems on linux
- by wizard
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?)