I'm using Javascript for my site, using Dreamweaver to create the pages. On my SQL Server I have created a DTS package that first recreates a table and then imports an Excel file.
I have created a Stored Procedure to launch this package. This part works great if launched from Query Analyzer. I want a user to be able to push a button which will launch the Stored Procedure and then return the results of how many records were imported.
From an asp page, i'm trying to auto-open a pop-up page if something exists. I can do this within access via vba using below code.
Anyone know how I could modify the below js to auto-lauch from asp?
sPage = "javascript:
resizeTo(478,500);moveTo(130,150);document.locatio n.href='http://myserver/myweb/mypopup.asp"
sApp = "c:Program FilesInternet Exploreriexplore.exe"
sCommand = sApp & " " & sPage & "'"
Call Shell(sCommand, 1)
I work on an existing application in ASP, which requires an access to DBAccess. I work on Win2K Professional and launch ISS. I have created both an administrator and a user count. The fact is that I can't launch ASP file in a browser. It results in asking me whether I want to register the file or whether I want to open it with an application on the hard disk.
I use FrontPage to edit ASP files. Using this software allows me to see the result of html but not the results of query (using DBAccess). I have yet declared an ODBC source refering to my Access database. I have also nstalled IIS.
But I can launch it only when Administrator!?? I have declared a virtual path to my web pages. But impossible to attain them in Netscape or IE.
I'd like to launch an executable file from a web page. Basically, the user
enters seven parameters and then clicks a button to generate a graph. The
input is written to a file and then read by the exe. The exe then generates
a graph based upon the input parameters.
I am reading about the Process class and wondering if that is the best
approach to this. Can you recommend a KB article?
I would like to run an ASP page each day at the same time automatically. it reads from my product data and ftps the data to another server.
I am running on a windows system with IIS I have no idea where to begin. Is there anything else I can do? it is not my own server so I don't have access to server. I can just ftp.
I'm writing an intranet-only browser based application. I need to launch either a SETUP.EXE that is on a network drive or a shortcut on a local drive that points to the exe on the network drive
I already know how to launch a local exe, for example:
Set objApp = CreateObject("WScript.Shell")
objApp.Run "cmd /C CD C: & Program Files & SomeFolder & SETUP"
I want to add an 'edit' link next to certain images that appears in my ASP application. When this link is clicked I want it to open an editor such as PhotoShop or MS Office Picture Manager with the picture. The only thing i can get it to do is to display the picture in the browser or ask me to download or execute the program.
I did some searching but couldn't find anything to help. It looks like other users with similar questions just gave up.
I want to use vbscript to run a script multiple times and save its results to a text file. I have practically wrote this script before but only using a sql command wrote in to the script. However, this is a lengthy sql file so can not be directly entered in to the vbs script,s o I would like to run it using sqlcmd.
"SQLCMD -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1)
I have tried Googling this problem but found very little information about it. Any discussions online that I have found show no code and assume you already know how to do it.
I have found this so far:
Set objShell = CreateObject("WScript.Shell")
Set objScriptExec = objShell.Exec("sqlcmd -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1))
But how do I get hold of the results in to some kind of variable?