> OK, let's try this: let's remove the **kwargs parameter, just in
> case that is causing the problem (you never told me what the printout
> was for this paramter!).
>
> So replace the connection line in dbMsSQL.py with:
>
> self._connection = pymssql.connect(host=host, user=user,
> password=password,
> database=database)
>
> ...and let me know how that works.
>
Hi Ed,
I got it! Well, I got the CD to work with Sql Server using Sql Auth
anyway. I'm going to leave Windows auth for another day. :-)
The problem turns out to be the host of "192.168.51.26:1433" vs.
"192.168.51.26". I added the following to pymssql.py and all is well:
(starting at line 341)
if host != "":
dbhost = host.split(":")[0]
#print "pymssql dbhost = ",dbhost
#dbhost = host
This effectively strips the port out of the host parameter. I'm not sure
that this is the right fix, or the right place to this? Perhaps you
would know better. This would seem to eliminate any hope of Dabo/pymssql
working with a Sql Server running on a non-standard port.
Thanks for the help! I'm going to forge ahead with my application
prototype tomorrow.
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]
