[web2py] Re: DAL connection to MSSQL

2016-04-06 Thread Brian M
You can do it but you must tell the DAL that the table exists. It won't just discovered existing tables for itself. -- 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 Is

[web2py] Re: DAL connection to MSSQL

2016-04-05 Thread Dave S
On Tuesday, April 5, 2016 at 8:47:17 AM UTC-7, Vu Pham wrote: > > Thank you for your information. > > One more question: > I have no problem to use this SQL statement db.executesql(select ) > with the same table name below. > but not db(db.tablename).select(...). > The system complains that

[web2py] Re: DAL connection to MSSQL

2016-04-05 Thread Vu Pham
Thank you for your information. One more question: I have no problem to use this SQL statement db.executesql(select ) with the same table name below. but not db(db.tablename).select(...). The system complains that the tablename is not defined. Is it true that any table created outside of DAL

[web2py] Re: DAL connection to MSSQL

2016-04-05 Thread Vu Pham
On Monday, April 4, 2016 at 12:47:03 PM UTC-7, Vu Pham wrote: > > Hi, > I created the 2012 MSSQL database in my local machine. > I am using db = DAL('mssql4://sa:pw@localhost/Unity). > The connection is established, and no error. > > However, I want to be sure it connects to right database. I am

[web2py] Re: DAL connection to MSSQL

2016-04-05 Thread Vu Pham
On Monday, April 4, 2016 at 12:47:03 PM UTC-7, Vu Pham wrote: > > Hi, > I created the 2012 MSSQL database in my local machine. > I am using db = DAL('mssql4://sa:pw@localhost/Unity). > The connection is established, and no error. > > However, I want to be sure it connects to right database. I am