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

Re: MS-SQL Stored Procedures - DBI

2002-08-29 Thread Roger Perttu
Michael Peppler wrote: >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 })

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 t

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 =

MS-SQL Stored Procedures - DBI

2002-08-29 Thread Michael Dalziel
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: DBI::errstr", 1,2); # DBI->trace(2); my $sth = $dbh->prepa