I tried solve it by myself, and I am out of my wits. Please point me where to look/what to read (RTMF is fine - just what page).
Problem: I am running IIS on Win2000 (%.00.2192), + Servce pack 2 ActiveState Perl 5.6.1 build 631 DBI 1.14 Oracle 8.0.5.0.0 for NT connecting via Oracle ODBC (file has date from 1998) I am not sure, but I think my troubles are caused by installing DBArtisan, rather old version 4.02 what was lying aroud (from 2/98). Since then (or close around), when I run my script, to connect to a database (over IP) takes 24 sec every time. I did not noticed immediately, because I am working to speed up my query, and it was slow (minutes) anyway, and I reloaded my table, etc, etc. When I am checking my connection using Oracle Net8 Easy Config, MS Access (linked table via ODBC), or even DBArtisan, access speed is fine. But when I try DBI->connect, it takes 24 secs. I did not changed "connect" parts of my code. ALso, exacly the same code, when run on our production server (Linux box), runs just fine, so I am pretty much sure some my own local setting are wrong. I tried to reinstall Oracle ODBC drivers, no change. I removed and re-created ODBC data sources, they are fine. Just my local perl scripts take 24 secs to connect. Another thing we did is oracle databse server was placed behind firewall. Where to look? Thanks a lot for any pointers. Peter
