Re: PERL and MS-SQL Server 2000

Although I do not have an experience with DBD::Sybase; module, the compilation error strictly shows an error in the use DBD::Sybase; line.

You probably need install this module "better"; unpacking could be not enough. Which directory you unpacked into?
Also, it could perfectly be your perl DLLs do not have executable permissions, or so.
(your file system is NTFS?)

Make stripped following excerpt from your code to pass compiling:

use DBI;
use DBD::ODBC;
use DBD::Sybase;
[download]

and I advice you to get rid of your following hack:

$ENV{SYBASE} = 'C:\Program Files\Microsoft SQL Server\80\Tools\BINN';
[download]

Comment on Re: PERL and MS-SQL Server 2000 Select or Download Code

Replies are listed 'Best First'.
Re^2: PERL and MS-SQL Server 2000 by derby (Abbot) on Apr 17, 2006 at 13:45 UTC
and I advice you to get rid of your following hack: $ENV{SYBASE} = 'C:\Program Files\Microsoft SQL Server\80\Tools\BINN'; If you're using DBD::Sybase, you need this line either in a BEGIN block or set in your environment before invoking the script. The sybase client libs use the environment variable SYBASE to locate the interfaces (or sql.ini for w32) file. The interfaces file is where the logical name of the database (used in the connection method) is mapped to the actual machine/port. -derby	[reply]
Re^3: PERL and MS-SQL Server 2000 by vkon (Curate) on Apr 17, 2006 at 14:50 UTC
all true, but such hard-coding of paths isn't good. You will have problems running this script elsewhere. Much better to find another way of supplying that ENV variable: helper .BAT, or real environment change, or finding installation path via registry, or whatever.	[reply]
Re^4: PERL and MS-SQL Server 2000 by jfroebe (Parson) on Apr 17, 2006 at 19:14 UTC
It depends on the scenerio. If the environment is a cookie cutter like situation where the servers all look alike, then there really isn't much danger. Deviate from the cookie cutter environment, then a more flexible solution is needed. Jason L. Froebe Team Sybase member No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1	[reply]