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.
