python-sybase-misc

[Python-sybase-misc] Python-Sybase module install questions

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

Hello,

I searched the Python-Sybase Archives however I did not find what I need. So
I post my question here.

My Sybase database sits on another computer in a different place. I know the
server's name for the computer. My qestions are
(1.) How to give Sybase directory in the "setup.py"?
(3.) Any information or webpage links that you can provide to me for such a
remote datababse case?

I work on Ubuntu.

Thanks so much

Re: [Python-sybase-misc] Python-Sybase module install questions

[Sébastien S. <sa...@us...>]

Hi "VV",

if your database server is on another computer, you still need to 
install Sybase client libraries on the client computer in order to 
compile and use python-sybase.

* the official version provided by sybase is called "open client":
http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/openclient

* there is an open source implementation called FreeTDS:
http://sourceforge.net/projects/freetds/
some people have reported that it works OK, though it may lake some 
features of the official client libraries

regards

--
Sébastien Sablé

VV W a écrit :
> Hello,
>  
> I searched the Python-Sybase Archives however I did not find what I 
> need. So I post my question here.
>  
> My Sybase database sits on another computer in a different place. I know 
> the server's name for the computer. My qestions are
> (1.) How to give Sybase directory in the "setup.py"?
> (3.) Any information or webpage links that you can provide to me for 
> such a remote datababse case?
>  
> I work on Ubuntu.
>  
> 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

Re: [Python-sybase-misc] Python-Sybase module install questions

[Lloyd K. <py...@ve...>]

On Tue, 2009-09-08 at 09:05 -0700, VV W wrote:
> Hello, 
>  
> I searched the Python-Sybase Archives however I did not find what I
> need. So I post my question here. 
>  
> My Sybase database sits on another computer in a different place. I
> know the server's name for the computer. My qestions are 
> (1.) How to give Sybase directory in the "setup.py"?
> (3.) Any information or webpage links that you can provide to me for
> such a remote datababse case?

If you are using freetds, you need to update your
        /etc/freetds/freetds.conf
file.  The samples from the end of the file are:

# A typical Sybase server
[egServer50]
	host = symachine.domain.com
	port = 5000
	tds version = 5.0

# A typical Microsoft server
[egServer70]
	host = ntmachine.domain.com
	port = 1433
	tds version = 7.0

Your Python code would look like
self.conn = Sybase.connect( egServer70, .....
where you reference the name you used in the freetds.conf file.

>  
> I work on Ubuntu. 
>  
> 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