Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by topmac

  1. topmac

    Run a Stored Proc. and return the results at the end

    The process I have here is a batch that triggers a bunch of ".exe" files on the server. [In a certain way, each step is linked with the prior step.] So this batch file must be executed as a single batch-run. If there is a way to just let the process run on the server and just once in a minute...
  2. topmac

    Run a Stored Proc. and return the results at the end

    Works just about good for most of the cases.... but sometimes, when the import process takes longer the process TimesOut. Is there a solution to it other than changing value in IIS admin tools. PMP Import Process Summary Active Server Pages error 'ASP 0113' Script timed out...
  3. topmac

    Run a Stored Proc. and return the results at the end

    thanks DotNetGnat... I'll try that first thing tomorrow morning...and post the result.
  4. topmac

    Run a Stored Proc. and return the results at the end

    Hi everyone, I have a ASP page that triggers a db-side stored procedure. At the end of the procedure, it spits out a log file, that this ASP page reads and displays for the users. But the problem is that the database-stored Proc could take anything between 10 secs - to - 10 mins. I dont want...
  5. topmac

    AspExec.exe Run batch file from ASP page

    hi everyone, I searched in faq's but couldn't find and solution... so here I post the popular question.. Env: Win2003 server / IIS6.0 Simple ASP page that runs a batch file. When I run the asp page, I see some command line window pop-up on my screen for a second [may be the "cmd" is...
  6. topmac

    Optional Query with in a Query

    Hi there, May be this is a popular issue.... but this is the first time for me. Any ideas are appreciated. select * from Table1 as t1 left outer join Table2 as t2 on t1.id = t2.id and t2.type in (case when <condition> then (1,2,3,4)...
  7. topmac

    Question about design practice - Address table

    thanks for your ideas guys.... I tried my best in one of our earlier meetings in my company to keep the data in its usual way ... and change it on the fly, when needed. But doesn't look likely that it'll stay that way. So I was looking for some strong points so I could make an impact in...
  8. topmac

    Question about design practice - Address table

    In a db, is it a good practice to have Address info in Address table in upper case or lower case? ex: street name, city, state, county, country etc.. How about name [first name, middle name, last name, prefix, suffix....] If you have any links that talk in detail about this, I'd like to read...
  9. topmac

    Net::SCP sample code

    I have activestate perl on a windows machine. 1 - So how do I create rsa keys...!! 2 - where do I run sys-keygen and other commands.... 3 - Where should these keys be saved for my perl process to see.. I am just a newbie...!! so I have whole bunch of other questions..!! but the ones above are...
  10. topmac

    Net::SCP sample code

    Looks like the login process is by RSA keys...! does anyone know if there is a good and simple tutorial to do this.. on a windows machine. any comments are greatly appreciated, thanks a lot, _Uday
  11. topmac

    Net::SCP sample code

    thanks for your reply Mike... don't we provide password to login....!! Also please post if you have any URL's with examples and tutorials..!! I really appreciate your help, _Uday
  12. topmac

    Net::SCP sample code

    Hi all, I am trying to write an automated process that hits a Linux server and SCP's files over to local machine. From CPAN I got the following code.... but it doesnt work for me. There is no error message either...!! Could you please give me a sample working code that has error handling...
  13. topmac

    Executing Applications on a Server Through an ASP Page

    thanks a lot again man..!! it was helpful. I'll try to go over the steps I did in setting this process and play with the persmissions a little bit.... See if I can figure this out.... In case if I have any questions I'll post them here..!! thanks a bunch again theniteowl, _Uday
  14. topmac

    Executing Applications on a Server Through an ASP Page

    Works like a charm...!! I can't thankyou enough for taking time to explain it clearly. I have a request though... Could you explain or throw some links that talk in detail about what you said... "requires that the computer itself have permission set in the database." I dont think I clearly...
  15. topmac

    Executing Applications on a Server Through an ASP Page

    I am trying to invoke a batch file on the server using a link/button on a ASP web page. I tried Set WShShell = Server.CreateObject("WScript.Shell") RetCode = WShShell.Run("C:\test1.bat") -***- Set Executor =...

Part and Inventory Search

Back
Top