Skip to Content.
Sympa Menu

freetds - Re: tds errors

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick Gigger" <Rick AT alpinenetworking.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: tds errors
  • Date: Thu, 29 Nov 2001 14:56:43 -0700


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')
>




Archive powered by MHonArc 2.6.24.

Top of Page