Buenas les comento que estoy comenzando con el desarrollo en python, a traves de django y sql server. Me he encontrado con un problema al conectarme a la base de datos, me genera el siguiente error y no conecta con la mism. La base se encuentra en un servidor exclusivo de BD dentro de la LAN.
El error se encuentra al ejecutar el comando manage.py, copio el resultado del proceso.
-----------------------proceso-
C:\PythonDev\logic_soft>python manage.py syncdb
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line
399, in execute_from_command_line
utility.execute()
File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line
392, in execute
self.fetch_command(subcommand).run_from_argv(self. argv)
File "C:\Python27\lib\site-packages\django\core\management\base.py", line 242,
in run_from_argv
self.execute(*args, **options.__dict__)
File "C:\Python27\lib\site-packages\django\core\management\base.py", line 285,
in execute
output = self.handle(*args, **options)
File "C:\Python27\lib\site-packages\django\core\management\base.py", line 415,
in handle
return self.handle_noargs(**options)
File "C:\Python27\lib\site-packages\django\core\management\commands\syncdb.py "
, line 57, in handle_noargs
cursor = connection.cursor()
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line 160,
in cursor
cursor = self.make_debug_cursor(self._cursor())
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line 132,
in _cursor
self.ensure_connection()
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line 127,
in ensure_connection
self.connect()
File "C:\Python27\lib\site-packages\django\db\utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line 127,
in ensure_connection
self.connect()
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line 115,
in connect
self.connection = self.get_new_connection(conn_params)
File "C:\Python27\lib\site-packages\sqlserver_ado\base.py", line 244, in get_n
ew_connection
conn = Database.connect(**conn_params)
File "C:\Python27\lib\site-packages\sqlserver_ado\dbapi.py", line 187, in conn
ect
mask_connection_string_password(connection_string)
django.db.utils.OperationalError: (com_error(-2147352567, 'Ocurri\xf3 una excepc
i\xf3n.', (0, u'ADODB.Connection', u'No se encontr\xf3 el proveedor especificado
. Es posible que no est\xe9 instalado correctamente.', u'C:\\Windows\\HELP\\ADO2
70.CHM', 1240655, -2146824582), None), u'Error opening connection: DATA SOURCE=2
00.100.100.16;Initial Catalog=Db_Explotacion_Informacion;UID=upublicta1; PWD=****
**;PROVIDER=SQLCLI11;MARS Connection=True')
C:\PythonDev\logic_soft>
---------fin proceso ---------------------
Les adjunto las capturas y les paso el codigo de conexion que es donde creo que esta el problema.
en settings.py :
DATABASES = {
'default': {
'ENGINE': 'sqlserver_ado', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
'NAME': 'Db_Explotacion_Informacion', # Or path to database file if using sqlite3.D
'USER': 'upublicta1', # Not used with sqlite3.
'PASSWORD': '123456', # Not used with sqlite3.
'HOST': '200.100.100.16', # Set to empty string for localhost. Not used with sqlite3.
'PORT': '', # Set to empty string for default. Not used with sqlite3.
'OPTIONS': {
'host_is_server': True,
'dsn': '200.100.100.16',
'use_mars': True,
"provider" : "SQLCLI11",
"extra_params" : "MARS Connection=True"
}
}
}
