> > On Fri, 2002-05-31 at 12:12, Kennis Koldewyn wrote: > > Temp tables don't seem to be "persistent" for me, that is, they > seem to disappear right after I create them. Here's my configuration: > > > > Perl: v. 5.6.1 (ActiveState build 631, under Microsoft Windows 2000) > > DBI: v. 1.23 (connecting to the database via ODBC) > > Database: Microsoft SQL Server 2000 > > My *guess* is that the two do() requests are using different physical > connections. However I don't know enough about DBD::ODBC to verify that > guess, or to give you a work-around.
Unless there is something explicit in the code, I wouldn't think so. DBD::ODBC shouldn't be creating a new connection. What version of DBD::ODBC are you using? Some of the more recent versions use SQLExecDirect when using do(), instead of the full prepare, etc. Is it possible that SQLExecDirect causes a problem (I doubt it). Is it possible that you have to quote the table name when using this syntax? Jeff
