FreeTDS Development Group

["Lee MacDonald" <lee.macdonald AT schneidertrading.com>]

I rebuilt apache and mod_python from the package manager, and this seems
to have fixed it, not entirely sure why :/

Cheers James, TDSDUMPCONFIG comes in useful.

Many Thanks.

- Lee.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: 23 May 2007 20:49
To: FreeTDS Development Group
Subject: Re: [freetds] apache/mod python freetds.conf problem

Lee MacDonald wrote:
> 
> I'm having this problem with apache/mod_python and freetds0.64 when
> trying to connect to a mssql server.
...
> error: DB-Lib error message 20009, severity 9:
> Server is unavailable or does not exist.
> 
> However, when running the same script from the command line it works
> fine.  I've tried playing with LD_LIBRARY_PATH's, moving the
> freetds.conf to different locations, but all with no luck.

LD_LIBRARY_PATH doesn't affect where freetds.conf is looked for.  Since
it
works from the command line and not under apache, perhaps the issue lies
with the webserver account's permissions?  If it can't read
freetds.conf,
that's pretty much the same as it not being there.  

You can use TDSDUMPCONFIG to show which files are consulted at connect
time.  

HTH.  

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
 

 
Schneider Trading
4th Floor,
25 Copthall Avenue
London EC2R 7BP

--------------------------------------------------------



Message from: lee.macdonald AT schneidertrading.com
Message to: freetds AT lists.ibiblio.org
Attached files: 0
This e-mail and any files transmitted with it are confidential, may be 
legally privileged, and are for the sole use of the intended recipient. 
Copyright in this e-mail and any accompanying document created by us is owned 
by us. If you are not the intended recipient of this e-mail or any part of it 
please telephone our IT Department at the number shown above or by e-mail at 
info AT schneidertrading.com. 
You should not use or disclose to any other person the contents of this 
e-mail or its attachments (if any), nor take copies. This e-mail is not a 
representation or warranty and is not intended nor should it be taken to 
create any legal relations, contractual or otherwise.
Schneider Trading Associates Ltd (Registration No. 3692131) is incorporated 
in England and Wales and the registered office is at 25 Copthall Avenue, 
London EC2R 7BP. The company is authorised and regulated by the Financial 
Services Authority