RE: DBD-ADO, Win32::OLE Error

2004-02-04 Thread Brian Cassidy
Hi Steffen, > -Original Message- > I don't know how aggregator.pl looks like, but I guess there are > global handles ($dh, $sth). Object destruction order during global > destruction is non-deterministic. Try to use lexical scoped variables: > > { > my $dbh = ... > > } aggregato

DBD-ADO, Win32::OLE Error

2004-02-03 Thread Brian Cassidy
2/OLE/Lite.pm line 154 during global destruction. Some stats on my setup: Windows 2000 Server Activestate Perl 5.8.0 Class::DBI 0.95 DBI 1.37 DBD::ADO 2.87 Win32::OLE 0.1403 Any help would be appreciated. -Brian Cassidy http://www.gordano.com - Messaging for educators.

RE: Odd Connection problem with DBD::ODBC, MS SQL 2000 and IIS on Win2k

2003-01-14 Thread Brian Cassidy
Hello thanks to Jeff and Thunder for their quick responses! Firstly, I upgraded DBD::ODBC to version 1.01 -- but that didn't help. Ah well. Next I tried Thunder's suggestion and ran the script on the command like and added a DBI->trace(9, 'trace.log'); to the script. In the output I noticed a una

Odd Connection problem with DBD::ODBC, MS SQL 2000 and IIS on Win2k

2003-01-13 Thread Brian Cassidy
Hello all, Sadly, I don't like how this question goes, but I'm at the end of my rope -- please bear with me :) I've created a simple script, which uses a DSN-less connection to grab some data from an MS SQL 2000 server and display it as XML. No big deal. I've installed Perl, DBI, DBD::ODBC and II