MS SQL Fustration

hacker_j99 has asked for the wisdom of the Perl Monks concerning the following question:

If anyone has advise on the following errors let me please know...
I believe that It may be the Dynamic Loader but I am not sure
Please help because its starting to get on my nerves.. And yes I have even stooped to the point of volunteering my own Mandrake machine for the cause

Why this was done
Connection for the Universoty of Toledo (my employeer) from a Sun to a MS SQL Server 7 ( the student information server with records of all students)

Here is my Setup

Sun Solaris 7 Sparc
Perl 5.6.1
FreeTDS .51 and/or .52 ( 2 different machines/paths same prob)
DBI 1.18
DBD::FreeTDS (.02 what ever www.cpan.org has the latest of)
DBD::Sybase ( 0.91 I beleive or the latest that I could get)

using dynamic - yes
dynamic postfix - so (standard i believe)
where dynaloader is at
/var/tmp/hfranks/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm

where perl is installed
/var/tmp/hfranks/bin/perl

other versions of perl but not used
/eng/local/bin/perl
/usr/local/bin/perl

location where the FreeTDS resides
/home/top/hfranks/hfranks2/hfranks1 - version .51
/home/top/hfranks/hfranks2/hfranks2 - version .52

$SYBASE = /home/top/hfranks/hfranks2/hfranks1 - at this time

$LD_LIBRARY_PATH =
/home/top/hfranks/hfranks2/hfranks1/lib:/usr/lib:/usr/ccs/lib:/opt/SUN
+Wspro/lib:/usr/dt/lib:/usr/openwin/lib:/usr/ucblib:/eng/local/lib:/en
+g/gnu/lib:/eng/local/X/R6/lib:/eng/applications/CenterLine/lib
[download]

Did FreeTDS Compile correctly - yes
Did DBD::Sybase Compile correctly - No make test failed
Did DBD::FreeTDS Compile correctly - No Make test failed

Errors can be found at

DBD::FreeTDS make test errors
http://www.eng.utoledo.edu/~hfranks/scripts/perl/work/errorDBDFreeTDS.txt

DBD::Sybase make test errrors
http://www.eng.utoledo.edu/~hfranks/scripts/perl/work/errorDBDSybase.txt

test script for use... Note that this is the Sybase one and FreeTDS uses simular
http://www.eng.utoledo.edu/~hfranks/scripts/perl/work/test.txt

Error while running DBD::FreeTDS
http://www.eng.utoledo.edu/~hfranks/scripts/perl/work/errorrunFreeTDS.txt

Error while running DBD::Sybase
http://www.eng.utoledo.edu/~hfranks/scripts/perl/work/errorrunSybase.txt

Run through of the Configure run on Perl
http://www.eng.utoledo.edu/~hfranks/scripts/perl/work/perlconfig.txt

Hacker_J99
UTC File Server For all your serving needs.

Comment on MS SQL Fustration Download Code

Replies are listed 'Best First'.
Re: MS SQL Fustration by strredwolf (Chaplain) on Aug 02, 2001 at 04:29 UTC
You may be using the wrong modules. Check DBIx::MSSQLReporter. -- $Stalag99{"URL"}="http://stalag99.keenspace.com";	[reply]
Re: MS SQL Fustration by mattr (Curate) on Aug 02, 2001 at 15:51 UTC
I believe you have to edit TestCommon.pm with your local server settings. (See this) Other possible answers.. be root, use perl <5.6,.. It also could be a chicken and egg of tds and dbd needing each other for tests. Please try again and tell us how it goes.	[reply]
Re: Re: MS SQL Fustration by hacker_j99 (Beadle) on Aug 03, 2001 at 20:57 UTC
I believe that the link is rather confusing when I have multiple ways of trying to connect DBD::Sybase uses a PWD file ( probably a smart move) and the DBD::FreeTDS uses the TestCommon.pm I did edit the TestCommon.pm for DBD::FreeTDS and managed to still make every test fail.... I will probably post my findings on my website under the Current projects. Thanks for the tips.. keep em rollin Hacker_J99 UTC File Server for all your File needs	[reply]