Automation Account error - when Try to call stored procedure from Automation account getting error:

Prajna Jena (ADM) 0 Reputation points
2024-05-07T11:21:41.09+00:00

Traceback (most recent call last): File "/usr/src/tmp/8643d647-6858-4b74-88c5-96b2e28a66f4/runbooks/Dravosa.py", line 30, in <module> cursor = source_engine.raw_connection().cursor() File "C:\userenv\lib\site-packages\sqlalchemy\engine\base.py", line 3300, in raw_connection return self.pool.connect() File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 449, in connect return _ConnectionFairy._checkout(self) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 1263, in _checkout fairy = _ConnectionRecord.checkout(pool) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout rec = pool._do_get() File "C:\userenv\lib\site-packages\sqlalchemy\pool\impl.py", line 180, in _do_get self._dec_overflow() File "C:\userenv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "C:\userenv\lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get return self._create_connection() File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 390, in _create_connection return _ConnectionRecord(self) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 674, in init self.__connect() File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 901, in __connect pool.logger.debug("Error on connect(): %s", e) File "C:\userenv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit raise exc_value.with_traceback(exc_tb) File "C:\userenv\lib\site-packages\sqlalchemy\pool\base.py", line 896, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "C:\userenv\lib\site-packages\sqlalchemy\engine\create.py", line 643, in connect return dialect.connect(*cargs, **cparams) File "C:\userenv\lib\site-packages\sqlalchemy\engine\default.py", line 620, in connect return self.loaded_dbapi.connect(*cargs, **cparams) pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,174 questions
0 comments No comments
{count} votes