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!

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

Search results for query: *

  1. chrisdq

    Resume Console session using remote desktop

    WhoKilledKenny, I'll install it on my WXP at home and try to connect to my work computer and hope this will solve my problem. Thanks
  2. chrisdq

    Resume Console session using remote desktop

    Hi, When using remote desktop to connect to a Windows 200 server, is there a way to resume the console session just like WXP? By default, Windows 2000 server opens a new session, but I want to connect to the the session that I opened already with everything opened. I tried adding the value...
  3. chrisdq

    Execute a windows program in T-SQL

    Awesome. Thanks.
  4. chrisdq

    Execute a windows program in T-SQL

    Do you guys have any suggestions for executing an ASP page as a recurring task? Would pasting the ASP code into the Job Scheduling in SQL Server work? I haven't tried it so I don't know if it can load include files and other external stuff.
  5. chrisdq

    Execute a windows program in T-SQL

    yeahh it's a good idea to host ASP server and SQL server separately. Thanks for all the help. You guys rock.
  6. chrisdq

    Execute a windows program in T-SQL

    >>because the function of a RDBMS is to serve and store data not do all kind of other stuff and waste precious CPU cycles. But If I use ASP to do things then doesn't it also use CPU cycles as well or running into "runaway process"? ASP is a server side language so it will use the same server to...
  7. chrisdq

    Execute a windows program in T-SQL

    Thanks Paul. If this is possible then I'm just curious to know why you would rather recommend me to implement this in ASP than T-SQL? Thanks again for all your help.
  8. chrisdq

    Execute a windows program in T-SQL

    I completely understand your point and I think it's possible to do this in ASP, in fact it would be easier for me to do it in ASP. I'm just trying to find out if this whole thing can be done from T-SQL so that the process would be quicker and it's more secure. With ASP, people can load the page...
  9. chrisdq

    Execute a windows program in T-SQL

    ptheriault, I don't know if it will work with the changable data/records that we have in the database. The whole process needs to be very customizable. How much does it cost to buy ViaWarp? We're a small team company I don't think we can afford for the service plus we already the tools for...
  10. chrisdq

    Execute a windows program in T-SQL

    Thanks all for your answers. I reason that I'm thinking of using T-SQL for 2 reasons 1) Using T-SQL to process hundreds/thousands records would be faster than from ASP. 2) This needs to be a recurring task that will run weekly. I haven't thought of how to execute an ASP page to run weekly but I...
  11. chrisdq

    Execute a windows program in T-SQL

    Hi all, I'm wondering Is it possible to execute a windows program using T-SQL and get the return values? If not what would be the best way? I'm using ASP and SQL Server for the website. I need to write a store procedure script to process customers' credit cards and this needs to call a credit...
  12. chrisdq

    Can't run script in IIS with Windows 2003 server

    I figured out the problem. It's in IIS applicationPool. Using a system account doesn't work so I have to use a NT account to log on to another server in other to access Source Safe repository and use an admin account to login in IIS directory security. Thanks
  13. chrisdq

    Can't run script in IIS with Windows 2003 server

    Hello, Does anyone know how to enable IIS in Windows 2003 server to run script like SS (ss is a dos-mode program from Source Safe)? I don't have any problem running it physically but somehow it SS doesn't work when running from the web (ASP). In IIS I have script and executable on and login...
  14. chrisdq

    can't run SS (Source Safe) script on Windows 2003

    Hello, Does anyone know how to enable Windows 2003 server to run SS (ss is a dos command for Source Safe) from dos? I don't have any problem running it physically but somehow it SS doesn't work when running from the web (ASP). I added security (read+write) to cmd.exe to remove access denied...
  15. chrisdq

    Why update statement doesn't work

    I got it to work. I was supposed to use rs.execute (sql) instead of rs.Open SQL, conn. Thanks everyone.
  16. chrisdq

    can't use update statement to connect to Access

    Thanks TheAceman1. I'm doing ok. How about you? what do I replace with DoCmd.RunSQL SQL? Could you please provide a sample of how to use your update query? I just can't figure out it works for select statement but not update. Thanks.
  17. chrisdq

    Why update statement doesn't work

    Hi, I can't figure out why the update query to access database doesn't work from ASP while it works fine with the select statement. Here is what is have for the update statement Public function testUpdate dim conn, rs, x, correctpass, username, sqlquery, SQL set...
  18. chrisdq

    can't use update statement to connect to Access

    Hi, I can't figure out why the update doesn't work from ASP while it works fine with the select statement. Here is what is have for the update statement Public function testUpdate dim conn, rs, x, correctpass, username, sqlquery, SQL set conn=Server.CreateObject("ADODB.Connection")...
  19. chrisdq

    Convert project .dsw from VS 6 to VS 2005 from command-line

    I tried devenv project.dsw /upgrade already but it didn't work. It prompted me to convert the file first. I was looking for another method to convert from .dsw to .sln without using the GUI (for automation purpose). This is where I'm stuck. Anyone has any idea? Thanks, Chris.
  20. chrisdq

    Convert project .dsw from VS 6 to VS 2005 from command-line

    Hi xwb, Thanks for your valuable info. Is there a way to automate the process of "start up the .dsw in 2005" then tell it to convert to .sln automatically from a batch script or something? I just thought that if we can use the GUI to convert .dsw project to .sln, then there must be a way to...

Part and Inventory Search

Back
Top