FreeTDS Development Group

["Stefan Hans" <shans AT tanagra.de>]

Hi James,

thx for your answer.

I've done the following to update freetds:

Script started on Mon Apr 21 20:36:48 2003
[root@linux1 local]# pwd
/usr/local
[root@linux1 local]#  gtar xf freetds-0.61.tar
[root@linux1 local]# cd freetds-0.61
[root@linux1 freetds-0.61]# ./configure --with-tdsver=8.0   --enable-dbmfix
[root@linux1 freetds-0.61]# gmake
[root@linux1 freetds-0.61]# export SYBASE=/usr/local/freetds
[root@linux1 freetds-0.61]# export LD_LIBRARY_PATH=$SYBASE/lib
[root@linux1 freetds-0.61]# cat /etc/ld.so.conf
/usr/kerberos/lib
/usr/X11R6/lib
/usr/lib/qt-2.3.1/lib
/usr/local/freetds/lib
[root@linux1 freetds-0.61]# ldconfig
[root@linux1 freetds-0.61]# cd ../php-4.2.0
[root@linux1 php-4.2.0]#
./configure --with-apache=../apache_1.3.22 --enable-trans-sid --with-sybase=
/usr/local/freetds --with-openssl=../openssl-0.9.6 --with-mm=../mm-1.1.3 --e
nable-track-vars
[root@linux1 php-4.2.0]# cd ../apache_1.3.22
[root@linux1 apache_1.3.22]# export SSL_BASE=/usr/local/openssl-0.9.6
[root@linux1 apache_1.3.22]# export EAPI_MM=../mm-1.1.3
[root@linux1 apache_1.3.22]#
./configure --enable-module=ssl --activate-module=src/modules/php4/libphp4.a
[root@linux1 apache_1.3.22]# make
[root@linux1 apache_1.3.22]# make certificate
[root@linux1 apache_1.3.22]# cat > ../freetds/etc/freetds.conf
[global]
        tds = 8.0
        host = 195.27.229.142
        port = 1433

[root@linux1 apache_1.3.22]#
[root@linux1 apache_1.3.22]# ../apache/bin/apachectl startssl
Script done on Mon Apr 21 20:59:59 2003

I've tested the following php code:

<?
// display_errors is on
// track_errors is on

error_reporting (E_ALL);

/* my tested procedure:
create procedure show_error
as
raiserror ('My Errortext', 18, 1)
*/

$sql = "exec show_error";

$php_errormsg = ''; // just to block: Notice: Undefined variable:
php_errormsg in ....

$conn = mssql_connect(...............) or die ($php_errormsg);

mssql_select_db('tsm') or die ($php_errormsg);

$query_result = mssql_query($sql) or die ("where is the errortext? -
".$php_errormsg);

// here i tested before if the error comes maybe with the resultset... no

?>

But only "where is the errortext? - " comes back.

What can I do? How can I test the freetds update?

Pls. give me an advice.

tia Stefan

----- Original Message -----
From: "Lowden, James K" <LowdenJK AT bernstein.com>
To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
Sent: Monday, April 21, 2003 4:09 PM
Subject: RE: [freetds] error-handling-bugs


> > From: Stefan Hans [mailto:shans AT tanagra.de]
> > Sent: April 20, 2003 11:11 AM
> >
> > we have problems with raiserror concerning an MS SQL Server 2000.
> >
> > Our configuration is:
> >
> > freetds-0.52 + php-4.2.0 + apache_1.3.22 on linux 2.4.18-3
>
> Error handling was completely rewritten for version 0.60, with additional
> improvements in 0.61.  I think you'll be much happier with 0.61.
Raiserror
> definitely works nowadays.
>
> --jkl
>
>
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or
agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>