I enabled set DBI TRACE=1. Please find the below TRACE log.

LOG:-

DBI 1.636-ithread default trace level set to 0x0/1 (pid 11108 pi 7c2ff
+4) at
DBI.pm line 296 via test_dbi.pl line 2
Trying to connect
    -> DBI->connect(dbi:ODBC:DSN=sql_test, **, ****)
    -> DBI->install_driver(ODBC) for MSWin32 perl=5.024000 pid=11108 r
+uid=0 euid
=0
       install_driver: DBD::ODBC version 1.52 loaded from C:/Perl/lib/
+DBD/ODBC.pm
    <- install_driver= DBI::dr=HASH(0x1d76c6c)
    !! The warn '0' was CLEARED by call to connect method
    <- connect('DSN=sql_test', '**', ...)= ( DBI::db=HASH(0x22ec33c) )
+ [1 items] at DBI.pm line 684
       info: '' '[Microsoft][ODBC SQL Server Driver][SQL Server]Change
+d database context to 'master'. (SQL-01000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language settin
+g to us_english. (SQL-01000)' (err#0)
    <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 736
       info: '' '[Microsoft][ODBC SQL Server Driver][SQL Server]Change
+d database context to 'master'. (SQL-01000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language settin
+g to us_english. (SQL-01000)' (err#0)
    <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 736
       info: '' '[Microsoft][ODBC SQL Server Driver][SQL Server]Change
+d database
 context to 'master'. (SQL-01000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language settin
+g to us_en
glish. (SQL-01000)' (err#0)
    <- STORE('Username', '**')= ( 1 ) [1 items] at DBI.pm line 739
       info: '' '[Microsoft][ODBC SQL Server Driver][SQL Server]Change
+d database
 context to 'master'. (SQL-01000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language settin
+g to us_english. (SQL-01000)' (err#0)
    <- connected('dbi:ODBC:DSN=sql_test', '**', ...)= ( undef ) [1 ite
+ms] at DBI.pm line 746
    <- connect= DBI::db=HASH(0x22ec33c)
       info: '' '[Microsoft][ODBC SQL Server Driver][SQL Server]Change
+d database context to 'master'. (SQL-01000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language settin
+g to us_english. (SQL-01000)' (err#0)
    <- STORE('dbi_connect_closure', CODE(0x1d6e5ac))= ( 1 ) [1 items] 
+at DBI.pmline 755
    !! The info '''' was CLEARED by call to prepare method
    <- prepare('Exec sp_listUsers '25329601','1'')= ( DBI::st=HASH(0x2
+2e969c) ) [1 items] at test_dbi.pl line 16
    <- execute= ( -1 ) [1 items] at test_dbi.pl line 18
-1
    <- DESTROY(DBI::st=HASH(0x22e9504))= ( undef ) [1 items] at test_d
+bi.pl line 20
    !! The info '''' was CLEARED by call to disconnect_all method
    <- disconnect_all= ( '' ) [1 items] at DBI.pm line 763
()!   <- DESTROY(DBI::dr=HASH(0x1d76c6c))= ( undef ) [1 items] during 
+global destruction
!   <- DESTROY(DBI::db=HASH(0x22ec264))= ( undef ) [1 items] during gl
+obal destruction
[download]

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.