Don't think you can. RowVersion is not a datetime, and can't be converted
to one. Web2py does not have a 'rowversion' type field. You can't update
it, and reading it isn't very useful unless you are doing opportunistic
locking or something similar.
On Monday, August 26, 2013 10:02:47 AM UTC-7, GregD wrote:
>
> Niphlod,
>
> You right, I didn't have to reimport the pyodbc. I'm connecting to the
> database now, but still getting an error.
>
> I think it has something to do with how I define the field RowVersion.
> RowVersion is defined as a timestamp data type in MS SQL Server 2012. How
> do I define that in the define_table function?
>
>
>
> On Friday, August 23, 2013 1:44:15 PM UTC-5, Niphlod wrote:
>>
>> seems that you're using the binary version. May I ask why do you need to
>> reimport pyodbc on your own ?
>> Why not just using db = DAL("mssql:// etc etc etc ") ?
>>
>> On Friday, August 23, 2013 8:09:45 PM UTC+2, GregD wrote:
>>>
>>> Hi,
>>>
>>> We're new to Web2py and starting to use it more and more to meet
>>> customer's demand for Web Apps. Currently, we need to create a few forms
>>> to retrieve info from production database system.
>>>
>>> Our environment is as follows:
>>> Windows Server 2008 R2
>>> SQL Server 2012 Standard
>>> IIS 7.0
>>>
>>> We've downloaded web2py and have forms created. However, we are having
>>> issues connecting to existing SQL Server database. Our DAL is as follows:
>>>
>>> import pyodbc
>>> from gluon.dal import MSSQLAdapter
>>> if not (MSSQLAdapter.driver):
>>> MSSQLAdapter.driver = pyodbc
>>> db = pyodbc.connect("DRIVER={SQL
>>> SERVER};SERVER=localhost\sqlexpress2012;DATABASE=Customer;UID=sa;PWD=***")
>>>
>>> We've defined the tables as follows:
>>>
>>> db.define_table('Locals',
>>> Field('id', 'int'),
>>> Field('Name', 'str'),
>>> Field('Logo', 'buffer'),
>>> Field('ActiveFlag', 'bool' ),
>>> Field('RowVersion', 'datetime.datetime'),
>>> Field('Address1', 'str'),
>>> Field('Address2', 'str'),
>>> Field('City', 'str'),
>>> Field('State', 'str'),
>>> Field('Zip', 'str'),
>>> Field('Phone', 'str'),
>>> Field('PrimaryContact', 'str'),
>>> Field('SecondaryContact', 'str'),
>>> Field('FaxTitle', 'str'),
>>> Field('TestingName', 'str'),
>>> Field('RecieveParts', 'str'),
>>> primarykey=[id],
>>> migrate=False)
>>>
>>> however, when we attempt to connect to database from admin page we get
>>> ...
>>>
>>> Traceback (most recent call last):
>>> File "/home/mdipierro/make_web2py/web2py/gluon/restricted.py", line 212,
>>> in restricted
>>> File "C:/web2py/applications/Reciprocity/models/db.py"
>>> <http://192.168.1.125:8000/admin/default/edit/Reciprocity/models/db.py>,
>>> line 61, in <module>
>>> AttributeError: 'pyodbc.Connection' object has no attribute 'define_table'
>>>
>>> It appears there is no define_table method in pyodbc, is that correct? If
>>> so, how should we model exsiting SQL Server tables using pyodbc?
>>>
>>>
--
---
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/groups/opt_out.
