[pyar] pyodbc y Sql Server 2014

[Fernando Riquelme]

Podrías probar con FreeTDS, espero te sirva.

DATABASES = {
     'default': {
         'ENGINE': 'sql_server.pyodbc',
         'NAME': 'xxx',
         'USER': 'xxx',
         'PASSWORD': 'xxx',
         'HOST': 'xxx.xxx.windows.net',
         'PORT': '1435',
         'AUTOCOMMIT': 'True',
         'CREATE_DB': 'True',
         'OPTIONS': {
             'driver': 'FreeTDS',
             'dsn': 'MSSQL-SGH',
             'autocommit': True,
             'host_is_server': True,
             'unicode_results': True,
             'extra_params': "TDS_VERSION=8.0"
         },
     },
}

2016-12-23 9:30 GMT-03:00 Javier Marcon <javiermarcon en gmail.com>:

> El 23/12/16 a las 08:14, Leandro Minatel escribió:
> > Hola Javier, en DRIVER proba con "SQL Server Native Client 11.0"
> >
> > Slds
> >
> Muchas gracias, pero cambiado el driver a SQL Server Native Client 11.0
> obtengo el error:
>
> <class 'pyodbc.Error'>('08001', '[08001] [Microsoft][SQL Server Native
> Client 11.0]Named Pipes Provider: Could not open a connection to SQL
> Server [2].  (2) (SQLDriverConnect); [HYT00] [Microsoft][SQL Server
> Native Client 11.0]Login timeout expired (0); [01S00] [Microsoft][SQL
> Server Native Client 11.0]Invalid connection string attribute (0);
> [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or
> instance-specific error has occurred while establishing a connection to
> SQL Server. Server is not found or not accessible. Check if instance
> name is correct and if SQL Server is configured to allow remote
> connections. For more information see SQL Server Books Online. (2)')
> (loguear.py)
>
> Saludos,
>
> Javier.
>
> --
> Eco red Natural.
> Veta de productos orgánicos y BPA.
> Totalmente naturales.
>
> _______________________________________________
> pyar mailing list pyar en python.org.ar
> http://listas.python.org.ar/listinfo/pyar
>
> PyAr - Python Argentina - Sitio web: http://www.python.org.ar/
>
> La lista de PyAr esta Hosteada en USLA - Usuarios de Software Libre de
> Argentina - http://www.usla.org.ar
>
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: <http://listas.python.org.ar/pipermail/pyar/attachments/20161223/b45671af/attachment.html>