hub and spoke using EIGRP
try to replace hub to swich
View Answer
| April 8, 2010 2:57 PM
EIGRP, Hub and Spoke, Routers, Routing protocols
try to replace hub to swich
View Answer
| April 8, 2010 2:57 PM
EIGRP, Hub and Spoke, Routers, Routing protocols
Conditional Hiding of Rows in Excel
I modified your code to use the Change event instead of the SelectionChange event, and use the Range parameter to hide the modified row. I think this should work: <pre>Private Sub Worksheet_Change(ByVal Target As Range) If Target.Value = “Completed” Then Target.EntireRow.Hidden = True Else Target.EntireRow.Hidden = False End If End Sub</pre> -CarlosDL ————
View Answer
| April 8, 2010 2:51 PM
conditional hiding rows, Excel VBA, Hiding rows
I modified your code to use the Change event instead of the SelectionChange event, and use the Range parameter to hide the modified row. I think this should work: <pre>Private Sub Worksheet_Change(ByVal Target As Range) If Target.Value = “Completed” Then Target.EntireRow.Hidden = True Else Target.EntireRow.Hidden = False End If End Sub</pre> -CarlosDL ————
View Answer
| April 8, 2010 2:51 PM
conditional hiding rows, Excel VBA, Hiding rows
RRAS stoping an outgoing VPN from working
Remove and re-install the original VPN software on all the pcs.
View Answer
| April 8, 2010 2:47 PM
RRAS, VPN
Remove and re-install the original VPN software on all the pcs.
View Answer
| April 8, 2010 2:47 PM
RRAS, VPN
Standby server back-up process
The passive node should take over in a matter of seconds to a few short minutes. Typically users will not even know it happened.
View Answer
| April 8, 2010 2:41 PM
Backup & recovery, Failover, Failover Clustering, Server administration, Server Backup
The passive node should take over in a matter of seconds to a few short minutes. Typically users will not even know it happened.
View Answer
| April 8, 2010 2:41 PM
Backup & recovery, Failover, Failover Clustering, Server administration, Server Backup
Vpro Technology
Intel® vPro™ Technology Notebook and desktop PCs with Intel vPro technology enable IT to take advantage of hardware-assisted security and manageability capabilities that enhance their ability to maintain, manage, and protect their business PCs. And with the latest IT management consoles from Independent Software Vendors (ISVs) with native Intel vPro technology support, IT can now [...]
View Answer
| April 8, 2010 2:09 PM
Intel, Intel Processors, Intel vPro
Intel® vPro™ Technology Notebook and desktop PCs with Intel vPro technology enable IT to take advantage of hardware-assisted security and manageability capabilities that enhance their ability to maintain, manage, and protect their business PCs. And with the latest IT management consoles from Independent Software Vendors (ISVs) with native Intel vPro technology support, IT can now [...]
View Answer
| April 8, 2010 2:09 PM
Intel, Intel Processors, Intel vPro
The best server to host a RHEL 5 PHP/MySQL script
Hard to answer since this would vary greatly. 1st) Is this a hosted solution? (Rackspace, etc.) If so, one of their entry Linux servers would suffice. Just confirm storage especially dealing with the various media you are dealing with. 2nd) If not hosted, is this server going to be located in a data center or [...]
View Answer
| April 8, 2010 1:55 PM
Linux, Linux Server Hosting, Red Hat Enteprise Linux
Hard to answer since this would vary greatly. 1st) Is this a hosted solution? (Rackspace, etc.) If so, one of their entry Linux servers would suffice. Just confirm storage especially dealing with the various media you are dealing with. 2nd) If not hosted, is this server going to be located in a data center or [...]
View Answer
| April 8, 2010 1:55 PM
Linux, Linux Server Hosting, Red Hat Enteprise Linux
What kind of failure event would cause a primary server to failover to a standby backup?
SQL Server Cluster provides both automatic and manual failover capability for SQL Server services to another node in case the active node is down. The active node can be down due to an operating system or a hardware failure in which case the automatic failover to an available node on the same cluster can happen [...]
View Answer
| April 8, 2010 1:32 PM
Failover, Failover Clustering, pulse beat testing
SQL Server Cluster provides both automatic and manual failover capability for SQL Server services to another node in case the active node is down. The active node can be down due to an operating system or a hardware failure in which case the automatic failover to an available node on the same cluster can happen [...]
View Answer
| April 8, 2010 1:32 PM
Failover, Failover Clustering, pulse beat testing
AS400 system cleanup
Hello, There are several things that could be eating up your disk space. You have journals, performance data, etc. You can go to GO PERFORM to see how many days of performance data you are saving, the library is normally QMPGDATA. Also for journal receivers….wrkobj *all/*all *jrnrcv or for jounals….wrkobj *all/*all *jrn. Not sure if [...]
View Answer
| April 8, 2010 3:48 AM
AS/400, PRTDSKINF
Hello, There are several things that could be eating up your disk space. You have journals, performance data, etc. You can go to GO PERFORM to see how many days of performance data you are saving, the library is normally QMPGDATA. Also for journal receivers….wrkobj *all/*all *jrnrcv or for jounals….wrkobj *all/*all *jrn. Not sure if [...]
View Answer
| April 8, 2010 3:48 AM
AS/400, PRTDSKINF
Authorization List
Look at group profiles? Phil Hi, No, as far as I know an object can only be secured by one authorisation list. Regards, Martin Gilbert. ============================================================ Since users can be on more than one *AUTL, there is no reason to have an object secured by more than one *AUTL. The only reason to have an [...]
View Answer
| April 8, 2010 3:27 AM
AUTL, iSeries, Security
Look at group profiles? Phil Hi, No, as far as I know an object can only be secured by one authorisation list. Regards, Martin Gilbert. ============================================================ Since users can be on more than one *AUTL, there is no reason to have an object secured by more than one *AUTL. The only reason to have an [...]
View Answer
| April 8, 2010 3:27 AM
AUTL, iSeries, Security
Faster File copy mechanism- Want to copy a huge data from one AS/400 file to another AS/400 file.
If the target file exists then indexes and journals on that file will slow the process. Other jobs can compete for the drives and other resources. Phil Hi, Do you need an exact copy of your file? In that case have you tried CRTDUPOBJ? Regards, Martin Gilbert. =============================================================== Try FTP. It is reasonably fast (compared [...]
View Answer
| April 8, 2010 3:19 AM
AS/400, CPYF, SAVF
If the target file exists then indexes and journals on that file will slow the process. Other jobs can compete for the drives and other resources. Phil Hi, Do you need an exact copy of your file? In that case have you tried CRTDUPOBJ? Regards, Martin Gilbert. =============================================================== Try FTP. It is reasonably fast (compared [...]
View Answer
| April 8, 2010 3:19 AM
AS/400, CPYF, SAVF
wrkqry command
Unless someone renamed the WRKOBJ command to something else and also renamed the DLTQRY command to WRKQRY, or did some similar obscure change such as adding a validity-checker to WRKOBJ, it is essentially guaranteed that your execution of WRKOBJ had nothing to do with the deletion of the query. Tom
View Answer
| April 8, 2010 1:30 AM
WRKQRY
Unless someone renamed the WRKOBJ command to something else and also renamed the DLTQRY command to WRKQRY, or did some similar obscure change such as adding a validity-checker to WRKOBJ, it is essentially guaranteed that your execution of WRKOBJ had nothing to do with the deletion of the query. Tom
View Answer
| April 8, 2010 1:30 AM
WRKQRY
passing array as parameter to stored procedure in mysql
AFAIK that is not allowed in MySql. You can, however, construct a comma separated string and pass it as a varchar.
View Answer
| April 8, 2010 12:38 AM
MySQL, MySQL Query Browser
AFAIK that is not allowed in MySql. You can, however, construct a comma separated string and pass it as a varchar.
View Answer
| April 8, 2010 12:38 AM
MySQL, MySQL Query Browser
2k3 dc w/ MIIS, adprep 2008, what will happen to MIIS?
Did you ever find an answer to your question? I’m dealing with the same issue. thanks!
View Answer
| April 8, 2010 12:15 AM
Adprep, MIIS, Windows Server, Windows Server 2003, Windows Server 2008
Did you ever find an answer to your question? I’m dealing with the same issue. thanks!
View Answer
| April 8, 2010 12:15 AM
Adprep, MIIS, Windows Server, Windows Server 2003, Windows Server 2008
Access 2003 – Setting Form’s Recordsource
AFAIK, the Access Jet engine doesn’t support CASE expressions. It worked in the Pass-through query because when using that type of query the command is sent directly to the external database (without being parsed by the Jet engine). Access <a href=”http://www.techonthenet.com/access/functions/advanced/iif.php”>IIF function</a> provides similar functionality. -CarlosDL ————–
View Answer
| April 8, 2010 12:14 AM
Access, Access 2003, Access 2003 forms
AFAIK, the Access Jet engine doesn’t support CASE expressions. It worked in the Pass-through query because when using that type of query the command is sent directly to the external database (without being parsed by the Jet engine). Access <a href=”http://www.techonthenet.com/access/functions/advanced/iif.php”>IIF function</a> provides similar functionality. -CarlosDL ————–
View Answer
| April 8, 2010 12:14 AM
Access, Access 2003, Access 2003 forms
Data center incident or disaster?
Problem management, which is closely related to incident management, analyzes the causes of incidents and identifies trends so that solutions to reduce the volume of incidents in the future may be developed. How much time is involved in the data center for incident and problem management? Our partner, Metrics Based Assessments, recently did an analysis, [...]
View Answer
| April 7, 2010 9:17 PM
DataCenter, Disaster Recovery, Incident response
Problem management, which is closely related to incident management, analyzes the causes of incidents and identifies trends so that solutions to reduce the volume of incidents in the future may be developed. How much time is involved in the data center for incident and problem management? Our partner, Metrics Based Assessments, recently did an analysis, [...]
View Answer
| April 7, 2010 9:17 PM
DataCenter, Disaster Recovery, Incident response
ORA-06550: line 224, column 7: error running in SQLPLUS
You have an EXCEPTION section for the UPDATE to table tfdscpm_sxb; but it’s not in it’s own block. Put a BEGIN before the UPDATE. Also, the Insert list before the VALUES keyword is missing the closing right paren.
View Answer
| April 7, 2010 8:13 PM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution
You have an EXCEPTION section for the UPDATE to table tfdscpm_sxb; but it’s not in it’s own block. Put a BEGIN before the UPDATE. Also, the Insert list before the VALUES keyword is missing the closing right paren.
View Answer
| April 7, 2010 8:13 PM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution
Generating Contracts Documents Automatically in Microsoft Access
It is possible, but plenty of coding will be required. I am currently working on a project that is creating contracts based on Access data. You can use the mail merge process to combine documents and get data from MS Access. The only problem is that if the data starts growing beyond 100000 rows (contracts), [...]
View Answer
| April 7, 2010 7:53 PM
Microsoft Access
It is possible, but plenty of coding will be required. I am currently working on a project that is creating contracts based on Access data. You can use the mail merge process to combine documents and get data from MS Access. The only problem is that if the data starts growing beyond 100000 rows (contracts), [...]
View Answer
| April 7, 2010 7:53 PM
Microsoft Access
Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control
Check out: http://www.everythingaccess.com/tutorials.asp?ID=Build-a-search-criteria-form
View Answer
| April 7, 2010 7:49 PM
Access Tables, ADODC, ComboBox, Microsoft Access
Check out: http://www.everythingaccess.com/tutorials.asp?ID=Build-a-search-criteria-form
View Answer
| April 7, 2010 7:49 PM
Access Tables, ADODC, ComboBox, Microsoft Access
Cancelling a print job from the Linux command line
Why do you ‘wait’ 2 sec with the cancel? If yo are testing to print small jobs, they will have gone “into the printer” before your cancel command is fired. Why don’t you start with that, and then do the more time-consuming lp command? Just an idea ….
View Answer
| April 7, 2010 7:40 PM
CUPS, Linux, Printing from Linux, Red Hat Enterprise Linux
Why do you ‘wait’ 2 sec with the cancel? If yo are testing to print small jobs, they will have gone “into the printer” before your cancel command is fired. Why don’t you start with that, and then do the more time-consuming lp command? Just an idea ….
View Answer
| April 7, 2010 7:40 PM
CUPS, Linux, Printing from Linux, Red Hat Enterprise Linux
