May be now people will start using mongodb and I will get all my question
answered! lol
On Thursday, May 7, 2015 at 11:58:06 AM UTC-4, Carl Petersen wrote:
>
> OK, obviously I approached this in the wrong manner. Sorry! I'm
> upgrading from 2.9.11-stable+timestamp.2014.09.15.23.35.11 to
> 2.10.4-stable+timestamp.2015.04.26.15.11.54
> and it looks like DAL has changed somewhat in that timeframe. For some
> reason it seems my sql server connections are unhappy (maybe related, maybe
> not). I'm getting the following error:
>
> db_gp_wspg = DAL('mssql3://DRIVER={ODBC Driver 11 for SQL
> Server};SERVER=server;DATABASE=database;port=port;domain=WSPG;UID=user;PWD=passwd',pool_size=1,check_reserved=None,migrate=False)
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/base.py",
> line 169, in __call__
> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/base.py",
> line 456, in __init__
> raise RuntimeError("Failure to connect, tried %d times:\n%s" %
> (attempts, tb))
> RuntimeError: Failure to connect, tried 5 times:
> Traceback (most recent call last):
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/base.py",
> line 434, in __init__
> self._adapter = ADAPTERS[self._dbname](**kwargs)
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/adapters/base.py",
>
> line 53, in __call__
> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/adapters/mssql.py",
>
> line 155, in __init__
> if do_connect: self.reconnect()
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/connection.py",
>
> line 126, in reconnect
> self.connection = f()
> File
> "/usr/local/lib/python2.7/dist-packages/pyDAL-15.03-py2.7.egg/pydal/adapters/mssql.py",
>
> line 153, in connector
> return self.driver.connect(cnxn, **driver_args)
> Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib
> '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0' : file not
> found (0) (SQLDriverConnect)")
>
> I have checked, and the file "libmsodbcsql-11.0.so.2270.0" is located in
> that directory, and is readable.
>
> If I have missed something obvious, my apologies. website maintainer is
> my part-time hat, and a new one at that!
>
> Thanks,
>
> Carl
>
> On Thursday, May 7, 2015 at 9:25:18 AM UTC-5, Niphlod wrote:
>>
>> still there.
>> https://github.com/web2py/pydal/blob/master/pydal/adapters/mssql.py .
>> noone removed anything.
>>
>> On Thursday, May 7, 2015 at 3:41:28 PM UTC+2, Carl Petersen wrote:
>>>
>>> Hello All,
>>>
>>> Working with the latest versions of web2py and it seems that my sql
>>> server connections are breaking. I noticed that a fairly large section of
>>> code related to MSSQLAdapter in gluon/dal.py has been taken out. Should I
>>> be approaching sql server connections differently now. I was previously
>>> using mssql3.
>>>
>>> Thanks,
>>>
>>> Carl
>>>
>>
--
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/d/optout.
