FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Ok, it is indeed new and also uses placeholders (maybe Michael is telling
me I need to get off my butt and get these implemented?)

Anyway, here is what I get run through gdb...perhaps you could run under
gdb (or other debugger) and when it hangs break and do a stack trace? Also
you may want to set TDSDUMP (e.g. export TDSDUMP=/tmp/freetds.log) and
post the output (beware your password will be contained in the log, so
change it if you are concerned w/ security...and who isn't :)

(gdb) run fail.t
Starting program: /usr/bin/perl fail.t
1..13
ok 1
ok 2
ok 3
ok 4
ok 5
Panic: dynamic SQL (? placeholders) are not supported by the server you
are connecting to at
/usr/lib/perl5/site_perl/5.005/i486-linux/DBD/Sybase.pm line 92.
Database handle destroyed without explicit disconnect.

Program exited with code 02.
(gdb)


On Fri, 24 Dec 1999, John Gilmore-Baldwin wrote:

> Well, I renamed the test that was hanging, fail.t, to xxx.t so it came
> last.  Here's my results:
> 
> dmr6:baldwin:17:DBD-Sybase-0.21:% make test
> PERL_DL_NONLAZY=1 /bin/perl -Iblib/arch -Iblib/lib
> -I/usr/local/lib/perl5/5.00503/sun4-solaris -I/usr/local/lib/perl5/5.00503
> -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;'
> t/*.t
> t/autocommit........ok
> t/base..............ok
> t/login.............ok
> t/main..............Changed database context to 'master'.
> Invalid object name 'sys_users'.
> Use of uninitialized value at t/main.t line 97.
> FAILED test 8
>         Failed 1/12 tests, 91.67% okay
> t/place.............?-style placeholders aren't supported with this SQL 
> Server.
> ok
> t/xxx...............
> 
> This seems much more promising, until it just hangs on fail.t.  Is this
> similar to what others see?
> 
> In the meantime, I'll grab a copy of sqsh and see what I get.
> 
> Thanks for the help,
> John
> 
> >On Thu, 23 Dec 1999, John Gilmore-Baldwin wrote:
> >
> >> I can't get tests to pass with DBD::Sybase-0.21 and freetds.  I compiled
> >> freetds with version set to 4.2 on Solaris, I set my environment variable
> >> for sybase to the freetds directory, and added my server to the 
> >> interfaces
> >> file there:
> >>
> >> MY_server1
> >>         query tcp ether 111.222.333.444 1433
> >>         master tcp ether 111.222.333.444 1433
> >>
> >>
> >> I also tried setting up the interfaces file like the regular sybase
> >> interfaces file, with hex numbers for the port and ip addresses, but that
> >> didn't do me well either.
> >>
> >The tli stuff (hex numbers) definately won't work.  We use sockets only,
> >sybase uses tli or socket depending on the platform.
> >
> >> Can anybody see the error of my ways?  I'm not having much luck debugging
> >> this myself.
> >>
> >Unfortunately the DBD::Sybase tests really only give you a pass/fail which
> >isn't terribly helpful.  Either run the test individually (go into the
> >test directory and run 'perl login.t' for instance. Otherwise get SQSH and
> >try to connect with that.  It's a lot more helpful in debugging simple
> >connectivity problems.
> >
> >> Thanks,
> >> John
> >>
> >
> >Brian
> >
> >
> >
> >---
> >You are currently subscribed to freetds as: john AT dwx.com
> >To unsubscribe, forward this message to
> >$subst('Email.Unsub')
> 
> 
> 
> 
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>