> Would you try something to see if we can figure this out? Below is
> code from dbMsSQL.py. The line numbers are the lines from the current
> version of the file; the lines without numbers are the debugging code
> I want you to insert.
>
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> 24 port = str(connectInfo.Port)
> 25 if not port or port == "None":
> 26 port = 1433
> 27 host = "%s:%s" % (connectInfo.Host, port)
> 28 user = connectInfo.User
> 29 password = connectInfo.revealPW()
> 30 database = connectInfo.Database
> 31
> 32 # hack to make this work. I am sure there is a better way.
> 33 self.database = database
> 34
> print "host:", host
> print "user:", user
> print "password:", password
> print "database:", database
> print "kwargs:", kwargs
> 35 self._connection = pymssql.connect(host=host, user=user,
> password=password,
> 36 database=database, **kwargs)
> 37 return self._connection
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> Now try running the dialog that isn't working, and post what gets
> printed out. If that's not the correct connection parameters, then we
> can figure out why.
>
Ed & Carl,
I did add this debug code, and got the results expected - everything
looks as it should, except the self._connection line does not work. It
times out as it always has for me.
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?
I've added debug code into pymysql (and it looks fine) but don't have
the ability/tools to dig into the .pyd file.
Thanks in advance for any assistance.
Bill.
_______________________________________________
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]
