Hello.

There is a code in sqlobject/mssql/mssqlconnection.py:

else: # pymssql
             self.dbconnection = sqlmodule.connect
             sqlmodule.Binary = lambda st: str(st)
             # don't know whether pymssql uses unicode
             self.usingUnicodeStrings = False
             self.make_conn_str = lambda keys:  \
                    ["", keys.user, keys.password, keys.host, keys.db]

However, pymssql.connect declaration is following:

def connect(server='.', user='', password='', database='', timeout=0,
          login_timeout=60, charset=None, as_dict=False,
          host='', appname=None, port='1433')

So seems make_conn_str produces wrong set of params which throws:

pymssql.InterfaceError: Connection to the database failed for an unknown 
reason.

(because actual host value is empty).

I've updated it like that:

self.make_conn_str = lambda keys:  \
                    [".", keys.user, keys.password, keys.db, 0, 60, 
None, False, keys.host, None, keys.port]

and things started to work.

Thanks.

------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to