Re: [web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2014-01-22 Thread Gianganh Nguyen
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 wrote: > I was also getting this same error and I thank Gianganh for his help i

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2014-01-16 Thread Josh Myers
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: " ('HY000', 'The driver did not supply an error!')" Gianganh, did you also get this error? Or, if you

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-26 Thread Gianganh Nguyen
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',

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-26 Thread Alan Etkin
> > 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 /databases/sql.log? Maybe you can post the last commands stored for debugging. -- Resources: -

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-25 Thread Gianganh Nguyen
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! But after I press F5, it is okay. Vào 06:17:49 UTC+7 Thứ năm, ngày 26 tháng mười hai năm 2013, Alan Etkin đã viết: > > In we

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

2013-12-25 Thread Alan Etkin
> > In web2py, if I use db = DAL('mssql://...), the error 'gluon.contrib.pypyodbc.ProgrammingError'> ('', '*SQL_INVALID_HANDLE*') > frequently occurs. > Can you please be more specific? What is the source code in you application producing the error? -- Resources: - http://web2py.