Я столкнулся с проблемой при подключении к azure sql с помощью django, пожалуйста, помогите мне [закрыто]
D:\CDP\Anomaly_Detection_Service\config\server_config.ini
System check identified no issues (0 silenced).
December 20, 2021 - 07:31:27
Django version 2.1.15, using settings 'core.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CTRL-BREAK.
title_name :>> asg
file_name :>> 536484573901199.csv
file_content :>> b't,a,b,c\n1,Wed Oct 13 15:43:22 GMT 2021,abc,india\n2,Wed Oct 13 15:43:22 GMT 2021,xyz,\n3,Wed Oct 13 15:43:22 GMT 2021,pqr,india\
n4,Wed Oct 13 15:43:22 GMT 2021,efg,japan\n'
[20/Dec/2021 07:31:46] "POST / HTTP/1.1" 200 8440
Internal Server Error: /save_filedetails
Traceback (most recent call last):
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\base.py", line 3240, in _wrap_pool_connect
return fn()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 310, in connect
return _ConnectionFairy._checkout(self)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 476, in checkout
rec = pool._do_get()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\impl.py", line 146, in _do_get
self._dec_overflow()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\langhelpers.py", line 70, in __exit__
compat.raise_(
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\impl.py", line 143, in _do_get
return self._create_connection()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 256, in _create_connection
return _ConnectionRecord(self)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 371, in __init__
self.__connect()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 666, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\langhelpers.py", line 70, in __exit__
compat.raise_(
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\create.py", line 590, in connect
return dialect.connect(*cargs, **cparams)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriver
Connect)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\django\core\handlers\exception.py", line 34, in inner
response = get_response(request)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response
response = self.process_exception_by_middleware(e, request)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\django\views\decorators\csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "D:\CDP\Anomaly_Detection_Service\app\views.py", line 104, in save_filedetails
title_id = azure_sql_conn.file_content(title_name, file_name)
File "D:\CDP\Anomaly_Detection_Service\Utility\connect_azure_sql.py", line 59, in file_content
conn = connect_engine.raw_connection()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\base.py", line 3273, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\base.py", line 3243, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\base.py", line 2097, in _handle_dbapi_exception_noconnection
util.raise_(
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\base.py", line 3240, in _wrap_pool_connect
return fn()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 310, in connect
return _ConnectionFairy._checkout(self)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 476, in checkout
rec = pool._do_get()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\impl.py", line 146, in _do_get
self._dec_overflow()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\langhelpers.py", line 70, in __exit__
compat.raise_(
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\impl.py", line 143, in _do_get
return self._create_connection()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 256, in _create_connection
return _ConnectionRecord(self)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 371, in __init__
self.__connect()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 666, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\langhelpers.py", line 70, in __exit__
compat.raise_(
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise_
raise exception
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\pool\base.py", line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\create.py", line 590, in connect
return dialect.connect(*cargs, **cparams)
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\sqlalchemy\engine\default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.InterfaceError: (pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified (0) (SQLDriverConnect)')
(Background on this error at: https://sqlalche.me/e/14/rvf5)
----------------------------------------
Exception happened during processing of request from ('127.0.0.1', 63591)
Traceback (most recent call last):
File "C:\Users\gcpuser\AppData\Local\Programs\Python\Python38\lib\socketserver.py", line 650, in process_request_thread
self.finish_request(request, client_address)
File "C:\Users\gcpuser\AppData\Local\Programs\Python\Python38\lib\socketserver.py", line 360, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "C:\Users\gcpuser\AppData\Local\Programs\Python\Python38\lib\socketserver.py", line 720, in __init__
self.handle()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\django\core\servers\basehttp.py", line 171, in handle
self.handle_one_request()
File "D:\venv\Anomaly_Detection_Service\lib\site-packages\django\core\servers\basehttp.py", line 179, in handle_one_request
self.raw_requestline = self.rfile.readline(65537)
File "C:\Users\gcpuser\AppData\Local\Programs\Python\Python38\lib\socket.py", line 669, in readinto
return self._sock.recv_into(b)
ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
----------------------------------------
Вернуться на верх