On Jun 13, 2007, at 12:57 PM, Bill Witherspoon wrote:
> Despite many different iterations on hostname, etc. I'm still getting
> the "Unable to make connection" error when I test the connection.
>
> I've connected to the DB using ODBC and that works. We're using
> Windows
> Authentication currently, and the DB box is inside our LAN so there
> shouldn't be any firewall-type issues.
Try this at a command prompt:
C:\> python
>>> import pymssql
>>> conn = pymssql.connect(host="myHost", user="myName",
password="myPassword",
database="myDatabase")
Of course, substitute the correct values for the parameters. Do you
get a connection? If not, try this at the command prompt:
C:\> telnet hostName 1433
Again, substitute the actual host name or IP address for 'hostName'.
Are you able to connect to the server over that port (which is the
default for MSSQL)?
-- 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]
