Se connecter à Mssql utilsant Perl sous unix

[IceFab]

Bonjour,

depuis quelques jours j'essaye de mettre en place un script sur mon serveur (ubuntu server) qui se connectera à une base de donnée MSSQL et rappatrira des infos (instances...)

On m'a conseillé d'installer le module ODCB pour perl , mais jy arrive pas , j'ai bien récupérer l'archive sur le CPAN , mais quand je la compile , j'ai une erreur du au langage du clavier .

je me tourne donc vers vous , aavez vous déja reussi a vous connecter a une BD MSSQL depuis un serveur Unix ? Si oui comment

Cordialement
Diplomats

[IceFab]

L'erreur que j'ai quand je compile mon programme avec odbc est :

Can't locate DBD/ODBC.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.12.4 /usr/local/share/perl/5.12.4 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.12 /usr/share/perl/5.12 /usr/local/lib/site_perl .) at ./mssql_monitoring.pl line 5.
BEGIN failed--compilation aborted at ./mssq.pl lin

[mamax29]

Heu.... question comment as-tu fais pour installer le module ODBC?

tape la commande suivant dans un terminal:

Code :

cpan -i DBD:ODBC

Cela installera le module ODBC
tu pourras ensuite tester ton script perl.

[IceFab]

Bonjour,

avant out désolé , j'aurai du créer ce sujet dans SGBD , c'est que maintenant que je vois cette section


quand j’exécute cette commande , a la compilation cela foire

# Failed test 'install ODBC'
# at t/01base.t line 30.
# Looks like you failed 1 test of 6.
t/01base.t ................... Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/6 subtests
(less 2 skipped subtests: 3 okay)
t/02simple.t ................. skipped: DBI_DSN is undefined
t/03dbatt.t .................. skipped: DBI_DSN is undefined
t/05meth.t ................... skipped: DBI_DSN is undefined
t/07bind.t ................... skipped: DBI_DSN is undefined
t/08bind2.t .................. skipped: DBI_DSN is undefined
t/09multi.t .................. skipped: DBI_DSN is undefined
t/10handler.t ................ skipped: DBI_DSN is undefined
t/12blob.t ................... skipped: DBI_DSN is undefined
t/20SqlServer.t .............. skipped: DBI_DSN is undefined
t/30Oracle.t ................. skipped: DBI_DSN is undefined
t/40UnicodeRoundTrip.t ....... skipped: DBI_DSN is undefined
t/41Unicode.t ................ skipped: DBI_DSN is undefined
t/50_odbc_utf8_on.t .......... skipped: DBI_DSN is undefined
t/70execute_array.t .......... skipped: DBI_DSN is undefined
t/odbc_describe_parameter.t .. skipped: DBI_DSN is undefined
t/pod-coverage.t ............. 1/1 # Test:od::Coverage 1.04 required for testing POD coverage
t/pod-coverage.t ............. ok
t/pod.t ...................... ok
t/rt_38977.t ................. skipped: DBI_DSN is undefined
t/rt_39841.t ................. skipped: DBI_DSN is undefined
t/rt_39897.t ................. skipped: DBI_DSN is undefined
t/rt_43384.t ................. skipped: DBI_DSN is undefined
t/rt_46597.t ................. skipped: DBI_DSN is undefined
t/rt_50852.t ................. skipped: DBI_DSN is undefined
t/rt_57957.t ................. skipped: DBI_DSN is undefined
t/rt_59621.t ................. skipped: DBI_DSN is undefined
t/rt_61370.t ................. skipped: DBI_DSN is undefined
t/rt_62033.t ................. skipped: DBI_DSN is undefined
t/rt_63550.t ................. skipped: DBI_DSN is undefined
t/rt_null_nvarchar.t ......... skipped: DBI_DSN is undefined
t/sql_type_cast.t ............ skipped: DBI_DSN is undefined

Test Summary Report
-------------------
t/01base.t (Wstat: 256 Tests: 6 Failed: 1)
Failed test: 4
Non-zero exit status: 1
Files=31, Tests=11, 5 wallclock secs ( 0.22 usr 0.22 sys + 1.04 cusr 0.44 csys = 1.92 CPU)
Result: FAIL
Failed 1/31 test programs. 1/11 subtests failed.
make: *** [test_dynamic] Erreur 255
MJEVANS/DBD-ODBC-1.31.tar.gz
/usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports MJEVANS/DBD-ODBC-1.31.tar.gz
Running make install
make test had returned bad status, won't install without force