T-SQL and access use different db engines; see this for example: http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html
On Sat, Mar 14, 2009 at 9:24 PM, Wes James <[email protected]> wrote: > > On Sat, Mar 14, 2009 at 8:00 PM, mdipierro <[email protected]> > wrote: > > > > As far as I understand ODBC provides a standard API for database > > connectivity but the SQL that goes through that connection still > > depends on the database backed. For example web2py can talk to MSSQL > > and DB2 and in both cases it uses pyODBC but the SQL translation > > strings in web2py are different. > > > > Am I missing something? > > > > Massimo > > > > This page has an example of pyODBC and ms access: > > http://en.wikibooks.org/wiki/Python_Programming/Database_Programming > > -wj > > <snip> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
