Hello Varsha,
For exemple if in my script sql "real.sql" there is commande line toto
I have this error :
Traceback (most recent call last):
File "./script_sql_4.py", line 19, in <module>
cur.execute(f.read().decode('utf-8'))
File "/usr/lib/pymodules/python2.7/pymssql.py", line 196, in execute
raise OperationalError, e[0]
pymssql.OperationalError: SQL Server message 2812, severity 16, state 62,
line 1:
Could not find stored procedure 'toto'.
DB-Lib error message 2812, severity 16:
General SQL Server error: Check messages from the SQL Server
I want get statut of my command "*cur.execute(f.read().decode('utf-8'))*"
in python after this command is execute
for after get log message error with this value.
Someone have any idea please ?
Thanks very much Community Ansible !! :)
Best Regards,
Le mardi 28 janvier 2020 12:33:03 UTC+1, P. Varsha a écrit :
>
> can you please share what actually error log you are getting.
>
> On Tue, Jan 28, 2020 at 4:13 PM Karther <[email protected] <javascript:>>
> wrote:
>
>> Hello,
>>
>> I have one script python script.py with this content :
>>
>> *#!/usr/bin/python*
>>
>> *import pymssql*
>>
>> *conn = pymssql.connect(host="ihospisql02", user="sa_ofs",
>> password="#Adm!n0fS1", database="my_database")*
>> *cur = conn.cursor()*
>>
>> *with open('real.sql') as f:*
>> * cur.execute(f.read().decode('utf-8'))*
>> * conn.commit()*
>>
>> *cur.close()*
>>
>>
>>
>> i want that when i execut this script in ansible, i have log error in
>> file or windows if there is error in this script ?
>>
>> Can you help me please ?
>>
>> Thanks very much guy !!
>>
>> Best Regards,
>>
>> Karther
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Ansible Project" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/ansible-project/f6435c57-b9f1-4f7b-9a7d-4209cbac5f0f%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/ansible-project/f6435c57-b9f1-4f7b-9a7d-4209cbac5f0f%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/38aa9485-37df-4b9b-872c-9befad489b08%40googlegroups.com.
