pyodbc error on windows machine

164 views
Skip to first unread message

jays...@gmail.com

unread,
Sep 7, 2023, 12:32:03 PM9/7/23
to web2py-users
Hello all, i have an app that is connect to MSSQL and is functioning normally when run on other machine, but when i run it i'm recieving this message:

pyodbc.DataError: ('22007', '[22007] [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. (241) (SQLExecDirectW)')

I'm not able to find the differences in ODBC drivers from my machine vs the machines that have no issues... but hoping someone could point me in the right direction

Thank you!

Jason

Clemens

unread,
Sep 7, 2023, 12:42:51 PM9/7/23
to web2py-users
Just because I've just read this a few minutes ago ... don't think this is the reason, but check it out or just be informed:
https://www.securonix.com/blog/securonix-threat-labs-security-advisory-threat-actors-target-mssql-servers-in-dbjammer-to-deliver-freeworld-ransomware/

jays...@gmail.com

unread,
Sep 7, 2023, 2:21:07 PM9/7/23
to web2py-users
thank you for pointing this out!

jays...@gmail.com

unread,
Sep 7, 2023, 8:49:29 PM9/7/23
to web2py-users
still hoping for some advice here

Niphlod

unread,
Sep 8, 2023, 7:47:08 AM9/8/23
to web2py-users
just as an off chance thing .... what's the default language of the user ? never had troubles with english. Also, what's your table model definition and what's the DDL for the underlying table ?
Reply all
Reply to author
Forward
0 new messages