I'm getting the error from a short pytest script:
>
> E pyodbc.ProgrammingError: ('42000', '[42000] [FreeTDS][SQL
>> Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS
>> options to be set for the connection. This ensures consistent query
>> semantics. Enable these options and then reissue your query. (7405)
>> (SQLExecDirectW)')
>
>
>>
>>
>> /usr/local/lib/python3.6/dist-packages/pydal/adapters/base.py:412:
>> ProgrammingError
>
> PyDAL shows the SQL command is:
command = "SELECT NacConnectionsView.eventdate,
NacConnectionsView.nacmacaddress, NacConnectionsView.nacswitch FROM
NacConnectionsView WHERE (NacConnectionsView.nacmacaddress LIKE '000000%'
ESCAPE '\\');"
Where did that [ESCAPE '\\'] part came from?
Thank you for any help!
--Wei Wang
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" 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/web2py/a4869e37-c631-4621-85be-e4d900de8da8%40googlegroups.com.
