From: Jonathan H. http://JonathansCorner.c. <chr...@gm...> - 2008-10-23 18:58:12
|
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 |
From: Jonathan H. http://JonathansCorner.c. <chr...@gm...> - 2008-10-24 13:32:16
|
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 |
From: Lloyd K. <py...@ve...> - 2008-10-24 15:15:57
|
Did you migrate your /etc/freetds.conf file? On Fri, 2008-10-24 at 08:32 -0500, Jonathan Hayward, http://JonathansCorner.com wrote: > Any hints? I searched for combinations of the last three lines of the > error message, and couldn't find anything. -- Lloyd Kvam Venix Corp DLSLUG/GNHLUG library http://dlslug.org/library.html http://www.librarything.com/catalog/dlslug http://www.librarything.com/rsshtml/recent/dlslug http://www.librarything.com/rss/recent/dlslug |