global.asa and DBI

[Mihai Razvan]

Hi list,   Two things:   1. Symbols defined in global.asa do not get imported in asp scripts. Example:   -- code --   our $dbh;   sub Script_OnStart {     $dbh=DBI->connect(...); ...   -- code --   The way I solved this is to provide an accesor function for $dbh but then I'm thinking that maybe "our" has lost it's purpose. Thoughts?   2. If this one is too off topic maybe you can just give some pointers (it might be related to my first problem). DBI calls work ... sometimes. Specifically, the "selectall_arrayref()" returns undef although it was succesfull with the same SQL statement a page ago.   My environment: Windows 2000 Professional SP2 Apache 1.3.22 ActivePerl 5.6.1 Apache::ASP 2.39 DBI 1.28 DBD::ODBC 0.43 - the db is mySQL 3.23.41 on a Linux server.   Thanks, Razvan