Search results for query: *

I have a pervasive database call sqn which is my production database. I want to make a copy of my production database as sqndev for testing, on the same server. I have no idea how to do this HELP Please. Thanks Tony ettienne (TechnicalUser) 25 Jun 09 8:42 You can copy the contents of the...

I have a pervasive database call sqn which is my production database. I want to make a copy of my production database as sqndev for testing, on the same server. I have no idea how to do this HELP Please. Thanks Tony

To All- How can I capture the IP address when I ping the server by it name? Thanks

To All- Below is what I have so far, I can only get the server name I need to get the server IP ADDRESS. Is there any way for me to get all the server IP ADDRESS? ---------------------------------------------------------- Sub ShowConnectAD Dim rootDSE set rootDSE =...

ALL- Is there a way to tell if a SERVER is up and running with a vbscript, I have the server IP Address and Name. Thanks Tony

I'm not sure how to access LDAP to export more than one field of data from LDAP. I need to get the user name, email address, user location. This is the code I'm using On Error Resume Next Dim qQuery, objConnection, objCommand, objRecordSet, obj Dim oRootDSE, strDomain Dim File1 Dim RF set fso...

To All- How can I check to see if a certain file exists on the SQL server from a store procedure. I have a store procedure that create a file if number of row is > 0. What I'm doing is schedule the store procedure to run from 6:00 AM thru 8:00 AM every 30 minute. I what it to only run if...

I have an Access database and for some reason the spell check is gray out, is there anyway I can get that to work. Thanks Tony

To All- I get permission denied when I'm trying to get the server name. Thanks for any help. tbscmgi ******************************************************** Sub ShowSVRIPAddress strComputer = "." Set objIPaWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set...

To All- I get permission denied when I'm trying to get the server name. Thanks for any help. tbscmgi ******************************************************** Sub ShowSVRIPAddress strComputer = "." Set objIPaWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set...

I'm trying to copy files from //is/prod TO //is/backup/prod under the prod folder there are sub-folders. When I try to copy I keep getting error path not found, and that because I don't have those sub-folderd created under the backup/prod folder. Is there anyway to make those sub-folder during...

To All- I'm trying to get all the file name from all of the sub foler, but I'm only getting up to 2 folder. Attach is my script Thanks for aly help. Tony dim sctr, fctr, c dim mfr, MFile dim wefp, dt ' ' Sub ShowOpeningOutputFile set MFile =...

To All- I'm new to Access Queires, I trying to get data from a table. My column name are as follow. ID Number Date Amount Account Select Account , Date from Cust where date between '010107' and '033107' and (here is where I'm having a problem) I need to get all account that is between the date...

I'm trying to copy folders/files from \\it\prod\*, to \\it\backup\prod but only if the folders/files does not exists in the \\it\backup\prod. I'm using vbscript. Thanks for any help in advance.

I have a number table with an account number and I want to find that account number in a balance table and when I find that account number I want the most recent one by date, if account not found I want to look in the previous month balance table. Thank for any help I can get.

To All- I have a VBScript on a flash drive, is there anyway to prevent anyone from editing it. Thanks Tony

To All- I'm trying to get the primary server name. I have 2 server, a backup and a primary per location. I'm getting the backup server name instead of the primary. The last 3 digits of the ip address tell identify the server, 195 is the primary. below is the script. Thanks for any help I can...

I'm trying to get a server name by passing the ip address. I have a primary server and backup server i only want the primary server name, that why I'm passing the IP address. Below is my script and error message. ----------------------------------------------------------- Sub ShowSVRIPAddress...

Hi- How can you pause or wait about 30 second after a call to a sub. I have a few call, but the first have to be finished before next to take affect. That why I want to put a pause or wait after a call. Thanks in advance for any help. Tony

Sub ShowFileCopy FCF = "A:\incoming.* " FCT = "P:\fedin_" & time & "_" & date & ".txt" FSO.CopyFile FCF , FCT , OverwriteExisting End Sub Thanks Tony