Recent content by chrisdq

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

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...

Awesome. Thanks.

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.

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

>>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...

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.

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...

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...

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...

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...

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

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...

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...

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