RE: MS-SQL Stored Procedures - DBI

2002-08-29 Thread Jeff Urlwin
Having difficulty with an error message no statement executing against the following my $dbh = DBI-connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit = 0, RaiseError = 0, PrintError = 0 }) or error(Can`t connect to db: DBI::errstr, 1,2); # DBI-trace(2); my $sth =

Re: MS-SQL Stored Procedures - DBI

2002-08-29 Thread Michael Peppler
On Thu, 2002-08-29 at 02:31, Michael Dalziel wrote: All, Having difficulty with an error message no statement executing against the following my $dbh = DBI-connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit = 0, RaiseError = 0, PrintError = 0 }) or error(Can`t connect to db:

Re: MS-SQL Stored Procedures - DBI

2002-08-29 Thread Michael Peppler
On Thu, 2002-08-29 at 05:53, Roger Perttu wrote: Michael Peppler wrote: On Thu, 2002-08-29 at 02:31, Michael Dalziel wrote: First of all you should print out any potential error messages, both for the prepare() and the execute() calls. Second, I believe that to get OUTPUT