This seems like a serious issue. Are you available to help us debug via
chat?
On Wednesday, 26 July 2017 09:41:58 UTC-5, Jaco wrote:
>
> Hi all,
> since updating from 2.14.6 to 2.15.2 I have a problem with accessing a
> remote MS-SQL Database. It does not recognize certain fields and always
> gives me an "incorrect syntax" error.
>
> This is the test with the "old" gluon:
> >>> from gluon2146 import DAL, Field
> >>> py =
> DAL("mssql://DRIVER={FreeTDS};SERVER=SERVERNAME\\INSTANCE;DATABASE=DATABASE;UID=USER;PWD=PASSWORD")
> >>> py.define_table('quelle',
> ... Field('quelleID', type='id', writable=False,
> readable=False, rname='Id',label = 'Quelle ID'),
> ... Field('QName', readable=False,
> writable=False,rname='Name'),
> ... Field('quelle_datum', type = 'date',comment='Datum der
> Quelle', label = 'Quellendatum'),
> ... Field('bemerkung','text', comment='Bemerkung zur
> Quelle', label = 'Bemerkung'),
> ... rname = 'tQuelle',
> ... fake_migrate=True
> ... )
> <Table quelle (quelleID, QName, quelle_datum, bemerkung)>
> >>>
> ... rows = py().select(py.quelle.ALL)
> >>> for row in rows[0:5]:
> ... print row.quelleID
> ...
> 4514
> 4515
> 4516
> 4517
> 4518
> >>> for row in rows[0:5]:
> ... print row.quelle_datum
> ...
> 2016-09-16
> 2016-09-16
> 2016-11-14
> 2016-09-16
> 2016-10-18
> >>>
>
> and this is with the new one:
> >>> from gluon import DAL, Field
> >>> py =
> DAL("mssql://DRIVER={FreeTDS};SERVER=SERVERNAME\\INSTANCE;DATABASE=DATABASE;UID=USER;PWD=PASSWORD")
> >>> py.define_table('quelle',
> ... Field('quelleID', type='id', writable=False,
> readable=False, rname='Id',label = 'Quelle ID'),
> ... Field('QName', readable=False,
> writable=False,rname='Name'),
> ... Field('quelle_datum', type = 'date',comment='Datum der
> Quelle', label = 'Quellendatum'),
> ... Field('bemerkung','text', comment='Bemerkung zur
> Quelle', label = 'Bemerkung'),
> ... rname = 'tQuelle',
> ... fake_migrate=True
> ... )
> <Table quelle (quelleID, QName, quelle_datum, bemerkung)>
> >>> rows = py().select(py.quelle.ALL)
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "/home/jacob/gluon/packages/dal/pydal/objects.py", line 2211, in
> select
> return adapter.select(self.query, fields, attributes)
> File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 760,
> in select
> return self._select_aux(sql, fields, attributes, colnames)
> File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 716,
> in _select_aux
> rows = self._select_aux_execute(sql)
> File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 710,
> in _select_aux_execute
> self.execute(sql)
> File "/home/jacob/gluon/packages/dal/pydal/adapters/__init__.py", line
> 67, in wrap
> return f(*args, **kwargs)
> File "/home/jacob/gluon/packages/dal/pydal/adapters/base.py", line 410,
> in execute
> rv = self.cursor.execute(command, *args[1:], **kwargs)
> pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect
> syntax near 'quelle_datum'. (102) (SQLExecDirectW)")
> >>>
>
> The table already exists and I am just trying to access the Data.
> If am am trying to only access the ID Field, it works.
>
> >>> rows = py().select(py.quelle.quelleID)
> >>> for row in rows:
> ... print row.quelleID
> ...
> 4514
> 4515
> 4516
>
> Does anyone know a workaround?
>
> Thanks in advance :)
>
--
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.
