Re: [Python-sybase-misc] pymssql connection problem

[VV W <vv...@gm...>]

Thanks Lloyd for your reply.

dsn is "None" by default so we can omit it without any problems. For "host",
if I use
host = "somehost.COM",
then my code gets the same error as I posted last time. Now I use
host="12.12.12.12:5000",  (5000 is a port number), then I get


File "/var/lib/python-support/python2.5/pymssql.py", line 328, in connect
    con = _mssql.connect(dbhost, dbuser, dbpasswd)
_mssql.error: Could not set connection properties

Did you install a python/sybase library module specially?



On Fri, Sep 11, 2009 at 5:39 AM, Lloyd Kvam <py...@ve...> wrote:

> 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 Pyt...@li...
> 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
>
>