Re: pymssql connection problem

Lloyd Kvam <[email protected]> Fri, 11 Sep 2009 08:39:03 -0400
Newsgroups	gmane.comp.python.sybase
Message-ID	<1252672743.29275.87.camel@venix-laptop>
On Thu, 2009-09-10 at 13:21 -0700, VV W wrote:
> Hello, 
>  
> I modified my script and tested again with 
>  
>  con=pymssql.connect(dsn='sybase-sever.mycompany.com', user='sa',
> password='',host="12.12.12.12",database='db-name')

        self.conn = pymssql.connect(
            host = "somehost.COM",
            user='someuser',
            password='somepassword',
            database='somedb',
            )

Works for me.  I don't know how to use the dsn parameter.  Does that
depend on ODBC configuration?

>  
> and now I got
>  
> 
>  File "/var/lib/python-support/python2.5/pymssql.py", line 328, in
> connect
>     con = _mssql.connect(dbhost, dbuser, dbpasswd)
> _mssql.error: DB-Lib error message 20009, severity 9:
> Unable to connect: Adaptive Server is unavailable or does not exist
> Net-Lib error during Operation now in progress
> Error 115 - Operation now in progress
> 
>  
> this is the problem that I got yesterday. It's really frustrating. 
>  
> Anybody can give me a clue? 
>  
> Thanks so much. 
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with 
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________ Python-sybase-misc mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/python-sybase-misc
-- 
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


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july