On Jun 18, 2007, at 2:24 PM, Bill Witherspoon wrote:
> I've experimented today by replacing the self._connection with a hard
> coded connection string as below:
>
> #fix this
> #self._connection = pymssql.connect(host=host, user=user,
> #password=password, database=database, **kwargs)
>
> #replaced with this:
> self._connection = pymssql.connect(host="192.168.51.26",
> user='plant_user', password="emseal01", database="testing")
>
> This actually works. Is it possible there is something going on
> transparently with string encoding (like Unicode)? Something that
> would
> print the expected result to screen but still be passing something
> unexpected to SQLServer?
Can you change your hard-coded string to:
self._connection = pymssql.connect(host=u"192.168.51.26",
user=u'plant_user', password=u"emseal01", database=u"testing")
...just to see if the mere presence of unicode strings is enough for
the connection to barf?
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
