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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.