fixes to "AS" on aliases, paramstyle default on ansisql

1 files changed, 6 insertions, 2 deletions

diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py
index 7205a5e9f..8aff72c47 100644
--- a/lib/sqlalchemy/ansisql.py
+++ b/lib/sqlalchemy/ansisql.py
@@ -44,7 +44,7 @@ class ANSISQLEngine(sqlalchemy.engine.SQLEngine):
         return ([],{})
 
     def dbapi(self):
-        return object()
+        return None
 
 class ANSICompiler(sql.Compiled):
     def __init__(self, engine, statement, bindparams, typemap=None, paramstyle=None,**kwargs):
@@ -57,7 +57,11 @@ class ANSICompiler(sql.Compiled):
         self.isinsert = False
         
         if paramstyle is None:
-            paramstyle = self.engine.dbapi().paramstyle
+            db = self.engine.dbapi()
+            if db is not None:
+                paramstyle = db.paramstyle
+            else:
+                paramstyle = 'named'
 
         if paramstyle == 'named':
             self.bindtemplate = ':%s'