[SQL-CVS] r1454 - SQLObject/branches/0.7-bugfix/sqlobject/mssql

[<sub...@co...>]

Author: phd
Date: 2006-01-03 12:20:29 +0000 (Tue, 03 Jan 2006)
New Revision: 1454

Modified:
   SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py
Log:
Merged a patch from rev. 1453.


Modified: SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py
===================================================================
--- SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py	2006-01-03 12:02:24 UTC (rev 1453)
+++ SQLObject/branches/0.7-bugfix/sqlobject/mssql/mssqlconnection.py	2006-01-03 12:20:29 UTC (rev 1454)
@@ -19,16 +19,26 @@
                 self.dbconnection = sqlmodule.connect
                 # ADO uses unicode only (AFAIK)
                 self.usingUnicodeStrings = True
+
+                # Need to use SQLNCLI provider for SQL Server Express Edition
+                if kw.get("ncli"):
+                    conn_str = "Provider=SQLNCLI;"
+                else:
+                    conn_str = "Provider=SQLOLEDB;"
+
+                conn_str += "Data Source=%s;Initial Catalog=%s;"
+
                 # MSDE does not allow SQL server login 
-                if "sspi" in kw and kw["sspi"]:
-                    self.make_conn_str = lambda keys: \
-                    ["Provider=SQLOLEDB;Data Source=%s;Initial Catalog=%s;Integrated Security=SSPI;Persist Security Info=False" % (
-                        keys.host, keys.db)]
-                    del kw["sspi"]
+                if kw.get("sspi"):
+                    conn_str += "Integrated Security=SSPI;Persist Security Info=False"
+                    self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
                 else:
-                    self.make_conn_str = lambda keys: \
-                    ["Provider=SQLOLEDB;Data Source=%s;User Id=%s;Password=%s;Initial Catalog=%s" % (
-                            keys.host, keys.user, keys.password, keys.db)]
+                    conn_str += "User Id=%s;Password=%s"
+                    self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db, keys.user, keys.password)]
+
+                col.popKey(kw, "sspi")
+                col.popKey(kw, "ncli")
+
             except ImportError: # raise the exceptions other than ImportError for adodbapi absence
                 import pymssql as sqlmodule
                 self.dbconnection = sqlmodule.connect