Hi, That doesn't work for me - it makes create_engine() hang for ages then fail. I wonder if this is because without a port, the driver first tries a named pipe connection. If you are keen to include this functionality, you'll have to do a bit more ground work.
The other issue you mention, with CoInitialize(), I have hit as well. I see this as an adodbapi bug, and unfortunately adodbapi is not maintained any more. This issue and others pushed me to pyodbc, which is working great. Paul El Gringo wrote: >I found that the conenctionString is not complete, the port is >missing. Not like anywhere else, host and port must be separated by a >comma ! > > >def make_connect_string(keys): > connectors = ["Provider=SQLOLEDB"] > connectors.append ("Data Source=%s,%s" % (keys.get("host"), >keys.get("port", 1433))) > connectors.append ("Initial Catalog=%s" % keys.get("database")) > user = keys.get("user") > if user: > connectors.append("User Id=%s" % user) > connectors.append("Password=%s" % keys.get("password", "")) > else: > connectors.append("Integrated Security=SSPI") > 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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---