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.
