I was also getting this same error and I thank Gianganh for his help in
moving me along.
Now, using the solution above, instead of getting the SQL_INVALID_HANDLE, I
am getting the following:
"<class 'pyodbc.Error'> ('HY000', 'The driver did not supply an error!')"
Gianganh, did you also get this error? Or, if you didn't, do you know how
I can fix this?
- Josh
On Thursday, December 26, 2013 10:13:36 PM UTC-5, Gianganh Nguyen wrote:
>
> Hey,
> I resolved this issue follow:
> 1. Setup pyodbc-3.0.7.win32-py2.7.exe (download from
> http://code.google.com/p/pyodbc/downloads/list)
> 2. Insert to the db.py file:
>
>
>
>
> *import pyodbc from gluon.dal import MSSQLAdapterif not
> (MSSQLAdapter.driver): MSSQLAdapter.driver =
> globals().get('pyodbc',None)*
>
> And everything is okay.
>
> Thanks!
> *(^_^)*
>
> Vào 00:21:28 UTC+7 Thứ sáu, ngày 27 tháng mười hai năm 2013, Alan Etkin đã
> viết:
>>
>> This error is produced when the controller files execute a query string,
>>> example db(db.usr).select() or db(db.usr).count(). It does not always occur
>>> but frequently occur!
>>>
>>
>> Have you checked <app>/databases/sql.log?
>>
>> Maybe you can post the last commands stored for debugging.
>>
>>
--
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].
For more options, visit https://groups.google.com/groups/opt_out.
