Re: [Python-sybase-misc] Trying to connect to MSSQL on wrong port?

[Jonathan H. http://JonathansCorner.c. <chr...@gm...>]

P.S. It also bombs out if I try to specify port 1433:

>>> database = Sybase.connect("[deleted]:1433", "[deleted]", "[deleted]")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "build/bdist.linux-i686/egg/Sybase.py", line 1194, in connect
  File "build/bdist.linux-i686/egg/Sybase.py", line 850, in __init__
  File "build/bdist.linux-i686/egg/Sybase.py", line 894, in connect
  File "build/bdist.linux-i686/egg/Sybase.py", line 250, in _clientmsg_cb
Sybase.DatabaseError: Layer: 0, Origin: 0
Unexpected EOF from the serverLayer: 0, Origin: 0
Adaptive Server connection failed
>>>

Any hints? I searched for combinations of the last three lines of the error
message, and couldn't find anything.

On Thu, Oct 23, 2008 at 1:58 PM, Jonathan Hayward,
http://JonathansCorner.com <chr...@gm...> wrote:

> I'm migrating a machine from Gentoo to Ubuntu (Intrepid), and am trying to
> get Sybase to talk to the database that the machine talked with before the
> upgrade.
>
> I'm running Ubuntu 8.0.4 with Python 2.5.2, Sybase 0.39, and Freetds 0.82.
> Sanitized output follows:
>
> >>> import Sybase
> >>> database = Sybase.connect("[deleted]", "[deleted]", "[deleted]")
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
>   File "build/bdist.linux-i686/egg/Sybase.py", line 1194, in connect
>   File "build/bdist.linux-i686/egg/Sybase.py", line 850, in __init__
>   File "build/bdist.linux-i686/egg/Sybase.py", line 894, in connect
>   File "build/bdist.linux-i686/egg/Sybase.py", line 250, in _clientmsg_cb
> Sybase.DatabaseError: Layer: 0, Origin: 0
> Unable to connect: Adaptive Server is unavailable or does not exist
> >>>
>
> Prior to the migration, those two would execute without errors and I would
> be able to move on.
>
> My sysadmin looked at it with netstat and said that it's trying to talk on
> port 4000, not 1433 as it should be.
>
> How can I make sure that my installation is trying to talk to the MSSQL
> server on the standard port? (Or are there other likely suspects?)
>
> --
> -- Jonathan Hayward, chr...@gm...
>
> ** To see an award-winning website with stories, essays, artwork,
> ** games, and a four-dimensional maze, why not visit my home page?
> ** All of this is waiting for you at http://JonathansCorner.com
>
> ++ Would you like to curl up with one of my hardcover books?
> ++ You can now get my books from http://CJSHayward.com
>



-- 
-- Jonathan Hayward, chr...@gm...

** To see an award-winning website with stories, essays, artwork,
** games, and a four-dimensional maze, why not visit my home page?
** All of this is waiting for you at http://JonathansCorner.com

++ Would you like to curl up with one of my hardcover books?
++ You can now get my books from http://CJSHayward.com