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 [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
-~----------~----~----~----~------~----~------~--~---
