Port has to be added to the connection string with pyodbc, the same
way as adodbapi and pymssql
def make_connect_string(self, keys):
connectors = ["Driver={SQL Server}"]
if keys.has_key("port"):
keys["host"] = keys["host"] + "," + str(keys["port"])
del keys["port"]
connectors.append("Server=%s" % keys.get("host"))
connectors.append("Database=%s" % keys.get("database"))
user = keys.get("user")
if user:
connectors.append("UID=%s" % user)
connectors.append("PWD=%s" % keys.get("password", ""))
else:
connectors.append ("TrustedConnection=Yes")
return [[";".join (connectors)], {}]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
