A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
The script runs from the asp page like this: <%if request.form("jobno")>"" then%> <script> window.open("export.vbs") </script> <%end if%> export.vbs below Option Explicit Dim objFSO, objFileCopy, objGuyFile, objFileDelete Dim strFilePath, strDestination, WinHttpReq Dim strFileText, strFileText2, strFileText3 dim fso strFilePath = "\\server1\jobs\source.txt" strDestination ="\\server2\export\destination" Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists(strDestination) then ' Delete file if it alread exists in the destination. fso.DeleteFile strDestination,True wscript.echo "File deleted from Server 2" else wscript.echo "File wasn't deleted." end if Set objFSO = CreateObject("Scripting.FileSystemObject") if objFSO.fileexists(strfilePath) then Set objFileCopy = objFSO.GetFile(strFilePath) ' copy the file to destination objFileCopy.copy (strDestination) WSCript.Echo "The new file has been Copied to " & strDestination Wscript.Quit else wscript.echo "This didn't work. New file WAS NOT copied." Wscript.Quit end if ' End of Script
|Connection String to remote Server not working||3||93|
|Need to install Microsoft Jet 4.0 driver on a Windows 2008 server or connect to Access database another way||3||66|
|Passing Parameter to Stored Procedure||4||27|
|return false must be hit after calling certain command||10||33|