Oh, I'm sorry because now I'm checking mail.
I didn't get that error. But I use driver pyodbc-3.0.7.win32-py2.7.exe for
python2.7.5.
Are you using what is python's version?
On Fri, Jan 17, 2014 at 5:57 AM, Josh Myers <dcbcyoungadu...@gmail.com>wrote:
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/gaP-XmMhMg0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*GianganhnguyenCS - Soict - Hust - K52*
*Mobile: 0975814385*
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
