Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
|
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 16th, 2006, 05:37 AM
Authorized User
 
Join Date: Jan 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem in scheduling a .vbs file

I have a vbs which pick data from a AS400 server and puts in sql server.I tried to schedule this .vbs file but it does not work. At the scheduled time, the .vbs program get opened in Interdev.

Is there any specific script that have to be written to schedule a vbs file.When i try to use the same code and run it using asp, it works. Please help me out with this.


Reply With Quote
  #2 (permalink)  
Old January 18th, 2006, 12:57 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Perhaps if you change the application associated with .vbs files from InterDev to ComSpec (cmd.exe)



mmcdonal
Reply With Quote
  #3 (permalink)  
Old January 20th, 2006, 02:01 AM
Authorized User
 
Join Date: Jan 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In my firm we are restricted to use only interdev. When i have to schedule this script on the server, and i guess its the problem with the settings. In the server we have to do some changes in the registery settings. could you please help me out with it. Do we have to use some cscript??

Reply With Quote
  #4 (permalink)  
Old January 20th, 2006, 08:25 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I am not sure why you can only use InterDev to run a script that won't work unless you run it using WScript or CScript or asp.

If you are trying to move files from one server to another, why don't you schedule a DTS package from the SQL Server? Or run the script from a workstation? I use scripts that run from workstations and send workstation data to a SQL server. You could just as easily pull data from the AS400 and send it to SQL. But a DTS package scheduled on the SQL Server is probably a better way to solve this.


mmcdonal
Reply With Quote
  #5 (permalink)  
Old January 24th, 2006, 05:29 AM
Authorized User
 
Join Date: Jan 2006
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have successfully scheduled the .vbs file, i tried scheduling it on the server and it works, but at the same time if i schedule it on my PC it dont work properly. what could be the problem? I had read that a .vbs file should always be scheduled on a domain machine.
Reply With Quote





Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I attach a file to an email in my .vbs file savoym VBScript 3 July 2nd, 2011 08:02 AM
Scheduling a .vbs execution pippil VBScript 4 June 30th, 2010 04:32 PM
Question on .vbs file savoym VBScript 2 February 24th, 2005 12:12 PM
Scheduling VBS file madhukp VBScript 1 September 22nd, 2004 07:14 AM
HELP with .VBS file savoym VBScript 1 July 31st, 2003 08:39 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.