Let me get this straight. How many network hops are the two machines apart? Server->gateway->router->router->router->gateway->server ????? or more???????? Are you pumping this back and forth in clear text????? You are not using message ques????? If the answer to all these questions is yes then I submit the your architecture is majorly flawed. Most application server vendor like to see the DB in the same subnet as as there server. That means no hops. Is there no way to get both boxes on the same subnet? You are compounding all this with a database that doesn't do transactions (rollback/commit on success/failure of a logical group of commands and you have an invitation for problems. PLEASE rethink what you are doing!!!!!!! ----- Original Message ----- From: "Pragneshkumar Gandhi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 09, 2000 6:46 AM Subject: 1) To increase TIMEOUT of DBI->connect function 2) perl on iis ?? > 1) > > Hello all perlurus > here pragnesh gandhi from india > i am accessing remote mysql through perl script > and it is working fine. > but some time if net is slow it is giving error > that > > test.pl: DBI->connect failed: Lost connection to MySQ > L server during query at test.pl line 27 > [Thu Nov 9 12:03:10 2000] test.pl: can't connect to > pragnesh :Lost connection t > o MySQL server during query at test.pl line > > but when net is speedy it is working very well. > i am guesing that this is happening due to some > timeout mechanism i can change connect_timeout > variable of mysqld but this is for server side. > but how can i change something on client side. so > my $dbh = DBI->connect() will wait for more time. > i am using linux,perl-cgi,DBI,DBD_MYSQL,apache. > > thanx in advanse > namaste > pragensh > > 2) > > one more questions > my combinations is > linux,cgi-perl,dbi,dbd-mysql,mysql,apache > shall i transfer it as > nt,cgi-perl,dbi,dbd-odbc,oracle,iis > shall iis supports perl (activeperl) > how can i do authrtications (repalcement of > .htaccess file) > thankx > pragnehs > > > ===== > ................... Never ever Give Up .............. > > FROM > PRAGNESHKUMAR GANDHI > > __________________________________________________ > Do You Yahoo!? > Thousands of Stores. Millions of Products. All in one Place. > http://shopping.yahoo.com/ > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users > _______________________________________________ Perl-Unix-Users mailing list. To unsubscribe go to http://listserv.ActiveState.com/mailman/subscribe/perl-unix-users
