FreeTDS Development Group

[Ingo Klein <klein AT zentraldata.de>]

Salute !

I've installed freetds v0.62.4 on Linux 
with apache 1.3.31 and PHP4.3.8.

If I check freetds with the toll tsql it seems thats working fine:

# ./tsql -C
locale is 
"LC_CTYPE=de_DE@euro;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C"
locale charset is "ISO-8859-15"
Compile-time settings (established with the "configure" script):
                           Version: freetds v0.62.4
    MS db-lib source compatibility: yes
       Sybase binary compatibility: unknown
                     Thread safety: no
                     iconv library: yes
                       TDS version: 5.0
                             iODBC: no
                          unixodbc: no
# /usr/local/freetds/bin/tsql -S hemera -U test -P test
locale is 
"LC_CTYPE=de_DE@euro;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C"
locale charset is "ISO-8859-15"
1> version
using TDS version 4.2
1> quit
#

But if I do it in PHP in this way:
$dbproc = mssql_connect("hemera","test","test")or 
die('Error:'.mssql_get_last_message());

results in:
Warning: mssql_connect(): Write to SQL Server failed. (severity 9) in 
/home/most/forms3/test/test.php on line 8
Warning: mssql_connect(): Login incorrect. (severity 9) in 
/home/most/forms3/test/test.php on line 8
Warning: mssql_connect(): Unable to connect to server: hemera in 
/home/most/forms3/test/test.php on line 8
Error:

But I dont find any entry in the log why?

And the Message "Write to SQL Server failed." is generated by freetds.

My question is:
What means this error-message(Write to SQL Server failed.)?

Are there not the correct rights for wwwrun in the filesystem
or are the environment-vars wrong....?
The environment vars are at the end of the mail.

I hope of a hint where can I search and test.

Tanks a lot!

Also denne, bis denne, viel Spasz noch, Ingo Klein.
----------------------------------------------
Environment
Variable Value
LESSKEY  /etc/lesskey.bin
MANPATH  
/usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome/share/man:/usr/local/mysql/man
INFODIR  /usr/local/info:/usr/share/info:/usr/info
NNTPSERVER  news
HOSTNAME  gdi41
XKEYSYMDB  /usr/X11R6/lib/X11/XKeysymDB
GNOME2_PATH  /usr/local:/opt/gnome:/usr
SHELL  /bin/bash
TERM  xterm
HOST  gdi41
HISTSIZE  1000
PROFILEREAD  true
SSH_CLIENT  ::ffff:1.1.1.74 2163 22
QTDIR  /usr/lib/qt3
SSH_TTY  /dev/pts/43
USER  root
JRE_HOME  /usr/lib/java/jre
LS_COLORS  
no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
XNLSPATH  /usr/X11R6/lib/X11/nls
HOSTTYPE  i386
PAGER  less
MINICOM  -c on
PATH  
/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/local/mysql/bin:/usr/local/mysql/libexec:/usr/lib/java/bin
MAIL  /var/mail/root
CPU  i686
JAVA_BINDIR  /usr/lib/java/bin
PWD  /root
INPUTRC  /etc/inputrc
JAVA_HOME  /usr/lib/java
SDK_HOME  /usr/lib/java
TEXINPUTS  :/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
HOME  /root
SHLVL  2
JDK_HOME  /usr/lib/java
OSTYPE  linux
LESS_ADVANCED_PREPROCESSOR  no
XCURSOR_THEME  crystalwhite
no_proxy  localhost
LS_OPTIONS  -a -N --color=tty -T 0
WINDOWMANAGER  /usr/X11R6/bin/kde
GTK_PATH  /usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0
LOGNAME  root
MACHTYPE  i686-suse-linux
LESS  -M -I
CVS_RSH  ssh
SSH_CONNECTION  ::ffff:1.1.1.74 2163 ::ffff:192.168.16.2 22
LC_CTYPE  de_DE@euro
LESSOPEN  lessopen.sh %s
PKG_CONFIG_PATH  /opt/gnome/lib/pkgconfig
INFOPATH  /usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
ACLOCAL_PATH  /opt/gnome/share/aclocal
LESSCLOSE  lessclose.sh %s %s
G_BROKEN_FILENAMES  1
COLORTERM  1
JAVA_ROOT  /usr/lib/java
_  /usr/local/apache/bin/httpd