FreeTDS Development Group

[Peter Moore <peter AT loved.com>]

Lance,
    what is the query? when testing anything to do with Sybase or MS SQL 
Server on a new site or new installation i always try and execute the sp_who 
stored  procedure from the client i am using. this procedure is by default 
allowed to be executed by all users who are members of the public group, and 
of course by the sa user. sometimes queries won't work due to permissioning 
on the backend so i really recommend that you use "exec sp_who" as your test 
query. using this as a test will eliminate permission errors. also, examine 
your Sybase log or in your case check the W2K event viewer logs for SQL 
Server errors.

cheers
peter
*******************************************
Peter Moore

peter AT loved.com
http://beos.loved.com/
ICQ 926967 (old) 95022055 (new - Oct 18, 2000)
*******************************************
> Our setup:
>   RedHat Linux
>   FreeTDS .52
>   MS SQL Server 7 and 2000
>   PHP 4.06 (the problem)
>
> We have installed FreeTds and it works. I downloaded SQSH and
> it was able to connect and query correctly.
>
> When try to run my test PHP script to connect and do a simple
> query I get this error:
>
>  Sybase: A link to the server could not be established
>
> The FreeTds lib directory was added to the ld.so.conf file and
> ldconfig ran.
>
> The LD_LIBRARY_PATH env variable was set as well as the SYBASE
> env variable. Apache stop and restarted.
>
> We moved the freetds.conf file out of the /opt/Freetds/etc directory
> and still got the same error. So it is like PHP is not correctly 
> finding the FreeTds stuff. I can look at phpinfo() and it says 
> sybase is enabled and shows my ./configure line that I typed in.
>
> What else could be the problem?
>
>Lance
>
>
>Have you seen http://www.norada.com/tour ?
>
>---
>You are currently subscribed to freetds as: [peter AT loved.com]
>To unsubscribe, forward this message to leave-freetds-
>134510C AT franklin.oit.unc.edu
>