tds errors

Rick Gigger Rick at alpinenetworking.com
Thu Nov 29 16:56:43 EST 2001


Yes, I will try to come up with some specific queries.

Would it be useful if I made them in PHP querying the Northwind database
so that you could implement them easily.

Rick

> -----Original Message-----
> From: Brian Bruns [mailto:camber at ais.org]
> Sent: Thursday, November 29, 2001 1:37 PM
> To: TDS Development Group
> Subject: [freetds] Re: tds errors
> 
> 
> Ok, I ran this script with both --with-sybase and 
> --with-sybase-ct and it
> worked both times. Can you send some more detail?
> 
> Brian
> 
> <html>
> <body bgcolor=white>
> <?php
> $dbproc = sybase_connect("server","user","password");
> if (! $dbproc) {
>         return;
> }<html>
> <body bgcolor=white>
> <?php
> $dbproc = sybase_connect("ibmcpg2dev_syb","sa","medication");
> if (! $dbproc) {
>         return;
> }
> $res = sybase_query("selectlajdkfkla",$dbproc);
> if (! $res) {
>         print "some error";
> }
> $res = sybase_query("select @@servername",$dbproc);
> if (! $res) {
>         print "some error";
> }
> while ($arr = sybase_fetch_array($res)) {
>         print $arr[0] . "<br>\n";
> }
> ?>
> </body>
> </html>
> $res = sybase_query("selectlajdkfkla",$dbproc);
> if (! $res) {
>         print "some error";
> }
> $res = sybase_query("select @@servername",$dbproc);
> if (! $res) {
>         print "some error";
> }
> while ($arr = sybase_fetch_array($res)) {
>         print $arr[0] . "<br>\n";
> }
> ?>
> </body>
> </html>
> 
> > I am using freetds 0.52 with php and apache, connecting to 
> MS SQL Server
> > 2000.
> > 
> > It seems as if any tds query error causes an error to occur within
> > freetds.  For instance in the past I have had foreign key violations
> > kill an entire apache process resulting in all subsequent 
> free tds calls
> > to simply report "1 is not a sybase link".  I am 
> experiencing the same
> > problem right now with doing selects and having an 
> unescaped ' in the
> > query.
> > 
> > It is causing HUGE problems because as soon as a tds error occurs
> > everything web app running on that box breaks and apache must be
> > restarted to fix it.
> > 
> > Are other people getting these errors?  I can give 
> specifics if needed
> > but it happens so often it seems as if they shouldn't be hard to
> > duplicate by just trying some random bad sql statements.
> > 
> > If needed I could help to hunt down as many as possible.
> > 
> > Rick Gigger
> 
> ---
> You are currently subscribed to freetds as: 
> [rick at alpinenetworking.com]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
> 



More information about the FreeTDS mailing list