VPN configuration
This thread may help you out. It can work but does take some playing around. You will need to be able to use debug and logging to figure out where any problems lie on both devices. —————————————————————————————— Just as Labnuke99′s thread states. Juniper cannot change the phase 2 lifetime timeout, so make sure to set [...]
View Answer
| June 14, 2013 8:08 PM
Authentication, Cisco, Cisco ASA 5520, Cisco IOS, Encryption, Firewalls, Juniper NetScreen-25, Juniper NS-25, VPN, VPN configuration, VPN security
This thread may help you out. It can work but does take some playing around. You will need to be able to use debug and logging to figure out where any problems lie on both devices. —————————————————————————————— Just as Labnuke99′s thread states. Juniper cannot change the phase 2 lifetime timeout, so make sure to set [...]
View Answer
| June 14, 2013 8:08 PM
Authentication, Cisco, Cisco ASA 5520, Cisco IOS, Encryption, Firewalls, Juniper NetScreen-25, Juniper NS-25, VPN, VPN configuration, VPN security
Open VPN server configuration
OpenVPN Installation: …content removed until permission is established. ================================= Please note that word-for-word copy/pasting of entire web pages is strongly frowned upon, especially when there is no attribution of original source. Tom
View Answer
| June 14, 2013 1:35 PM
OpenVPN, Virtual Private Network, VPN, VPN configuration, Windows XP
OpenVPN Installation: …content removed until permission is established. ================================= Please note that word-for-word copy/pasting of entire web pages is strongly frowned upon, especially when there is no attribution of original source. Tom
View Answer
| June 14, 2013 1:35 PM
OpenVPN, Virtual Private Network, VPN, VPN configuration, Windows XP
STRSQL command
Hi, Yes you can, but it will only work interactively. It’s probably better to look at one of the alternatives like RUNSQLSTM. Regards, Martin Gilbert. if you are a heavy SQL shoppe, you may want to develop prototypes in RPG that use strings passed from CL, in order to execute the command. also, the product [...]
View Answer
| June 14, 2013 1:09 PM
CL, CL Program, STRSQL
Hi, Yes you can, but it will only work interactively. It’s probably better to look at one of the alternatives like RUNSQLSTM. Regards, Martin Gilbert. if you are a heavy SQL shoppe, you may want to develop prototypes in RPG that use strings passed from CL, in order to execute the command. also, the product [...]
View Answer
| June 14, 2013 1:09 PM
CL, CL Program, STRSQL
LAN connectivity problem with Compaq notebook
I would like to add the following to my question: - The notebook has Win XP Pro(SP 1) installed in it. - The LAN uses DHCP through Win 2k server.
View Answer
| June 14, 2013 3:47 AM
Business/IT alignment, Cabling, CRM, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Desktop management applications, Desktops, DHCP, DNS, E-business, Ecommerce applications, Ethernet, Firewalls, Forensics, Hardware, Hubs, Incident response, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, NIC, OS, Patch management, Routers, Security, Servers, Software, SQL Server, Switches, TCP, Tech support, Training, VPN, Wireless
I would like to add the following to my question: - The notebook has Win XP Pro(SP 1) installed in it. - The LAN uses DHCP through Win 2k server.
View Answer
| June 14, 2013 3:47 AM
Business/IT alignment, Cabling, CRM, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Desktop management applications, Desktops, DHCP, DNS, E-business, Ecommerce applications, Ethernet, Firewalls, Forensics, Hardware, Hubs, Incident response, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, NIC, OS, Patch management, Routers, Security, Servers, Software, SQL Server, Switches, TCP, Tech support, Training, VPN, Wireless
LAN connectivity problem
Try using the port and cable on another computer. If it works with that computer, then the NIC on the problem computer is bad. If it still doesn’t work, replace the cable. If it still doesn’t work, try another switch port. Both cables and switch ports can fail. first ping 127.0.0.1 from laptop if it [...]
View Answer
| June 14, 2013 7:53 AM
LAN, LAN Connections, Local area networks, Network connectivity
Try using the port and cable on another computer. If it works with that computer, then the NIC on the problem computer is bad. If it still doesn’t work, replace the cable. If it still doesn’t work, try another switch port. Both cables and switch ports can fail. first ping 127.0.0.1 from laptop if it [...]
View Answer
| June 14, 2013 7:53 AM
LAN, LAN Connections, Local area networks, Network connectivity
SMTP transmission failure has occurred using Exchange 2003 and Trend Micro IMSS
Each session is limited to 500 messages. The easy way to “solve” this is to increase your maximum. I don’t really recommend this. Instead follow the advice in this discussion and the MSKB article here. Also double check to make sure you exclude the proper directories from your AV here and here.
View Answer
| June 14, 2013 11:23 PM
Exchange 2003, IMSS, SMTP
Each session is limited to 500 messages. The easy way to “solve” this is to increase your maximum. I don’t really recommend this. Instead follow the advice in this discussion and the MSKB article here. Also double check to make sure you exclude the proper directories from your AV here and here.
View Answer
| June 14, 2013 11:23 PM
Exchange 2003, IMSS, SMTP
SMTP transmission failure has occurred when sending to Yahoo mail server
The error message pretty much says it. “This account has been temporarily suspended.” The user at yahoo.com that you are trying to email has had their account suspended for some reason.
View Answer
| June 14, 2013 6:11 PM
SMTP, SMTP transmission failure
The error message pretty much says it. “This account has been temporarily suspended.” The user at yahoo.com that you are trying to email has had their account suspended for some reason.
View Answer
| June 14, 2013 6:11 PM
SMTP, SMTP transmission failure
AS/400 query by date
I read your question as “..how can I find queries created within a certain period”. Use the DSPOBJD command to create a temporary file with object information : <pre> DSPOBJD OBJ(mylib/*ALL) OBJTYPE(*QRYDFN) OUTPUT(*OUTFILE) OUTFILE(QTEMP/myfile) </pre> Run query on the file and you ill find the field with the objects creation date. Did I get your [...]
View Answer
| June 14, 2013 2:27 PM
AS/400
I read your question as “..how can I find queries created within a certain period”. Use the DSPOBJD command to create a temporary file with object information : <pre> DSPOBJD OBJ(mylib/*ALL) OBJTYPE(*QRYDFN) OUTPUT(*OUTFILE) OUTFILE(QTEMP/myfile) </pre> Run query on the file and you ill find the field with the objects creation date. Did I get your [...]
View Answer
| June 14, 2013 2:27 PM
AS/400
AS/400-DDL: Create table command
<ul> For generating SQL source:</ul> If you have the iseries navigator, go to <machine> Databases <machine> Schemas <library> Tables. Right click on the required table and select ‘Generate SQL’. Do remember to click checkbox ‘include object short names’, in case the table has column/field names more than 10 chars long. <ul> For DDS source:</ul> On [...]
View Answer
| June 14, 2013 11:15 AM
Data Definition Language, DDL, DDL Create Table
<ul> For generating SQL source:</ul> If you have the iseries navigator, go to <machine> Databases <machine> Schemas <library> Tables. Right click on the required table and select ‘Generate SQL’. Do remember to click checkbox ‘include object short names’, in case the table has column/field names more than 10 chars long. <ul> For DDS source:</ul> On [...]
View Answer
| June 14, 2013 11:15 AM
Data Definition Language, DDL, DDL Create Table
SharePoint Calendar deadlines/events
I would rather take your requirement as a “alert me” problem. Default SharePoint “Alert Me”, However, can not do that. If this requirement is crucial to you , then I recommend you take a look at SharePoint Alert Reminder Boost. Its reminder feature can do what you want.
View Answer
| June 14, 2013 10:00 AM
Lotus Notes 6.x, SharePoint, SharePoint 2007
I would rather take your requirement as a “alert me” problem. Default SharePoint “Alert Me”, However, can not do that. If this requirement is crucial to you , then I recommend you take a look at SharePoint Alert Reminder Boost. Its reminder feature can do what you want.
View Answer
| June 14, 2013 10:00 AM
Lotus Notes 6.x, SharePoint, SharePoint 2007
SharePoint Calendar item
Did you ever figure this out? We’re getting the same behavior. Also, if an appointment has a specific time start and ending, all that displays is “1 more item”, not even the event name. If we change the event to all day, it displays.
View Answer
| June 14, 2013 1:46 AM
SharePoint, SharePoint calendar
Did you ever figure this out? We’re getting the same behavior. Also, if an appointment has a specific time start and ending, all that displays is “1 more item”, not even the event name. If we change the event to all day, it displays.
View Answer
| June 14, 2013 1:46 AM
SharePoint, SharePoint calendar
Opcode in RPG that retrieves current date
The TIME opcode with a 14-digit result field, the %DATE built-in, or the %TIMESTAMP built-in are three that come to mind. ================================================== The DATE positions 191-198 of the program status data structure provides a 4-digit year. Tom
View Answer
| June 14, 2013 10:46 AM
AS/400, RPG
The TIME opcode with a 14-digit result field, the %DATE built-in, or the %TIMESTAMP built-in are three that come to mind. ================================================== The DATE positions 191-198 of the program status data structure provides a 4-digit year. Tom
View Answer
| June 14, 2013 10:46 AM
AS/400, RPG
Current date in DB2/400
select current date from myfile Did you mean in SQL on DB2/400? ====================================================== The default value for a DATE field is CURRENT DATE. The default value for a TIMESTAMP field is CURRENT TIMESTAMP. There is no need for a field-level keyword which is probably why there is none. Tom
View Answer
| June 14, 2013 5:00 AM
DB2/400, Field-Level keywords
select current date from myfile Did you mean in SQL on DB2/400? ====================================================== The default value for a DATE field is CURRENT DATE. The default value for a TIMESTAMP field is CURRENT TIMESTAMP. There is no need for a field-level keyword which is probably why there is none. Tom
View Answer
| June 14, 2013 5:00 AM
DB2/400, Field-Level keywords
AS/400 TCP/IP: Port numbers
Typical destination ports are 80 – http and 443 – https. Other ports may be used as defined by the site. Source ports are typically greater than 1024 and will vary from system to system. — You can find a document here. The text summary of that page: <pre> The text summary of that page: [...]
View Answer
| June 14, 2013 4:14 AM
AS/400 networking, AS/400 Port Numbers, Port numbers, TCP/IP
Typical destination ports are 80 – http and 443 – https. Other ports may be used as defined by the site. Source ports are typically greater than 1024 and will vary from system to system. — You can find a document here. The text summary of that page: <pre> The text summary of that page: [...]
View Answer
| June 14, 2013 4:14 AM
AS/400 networking, AS/400 Port Numbers, Port numbers, TCP/IP
Stop and Start AS/400 TCP/IP
endtcp and strtcp
View Answer
| June 14, 2013 11:43 PM
AS/400 administration, AS/400 TCP/IP
endtcp and strtcp
View Answer
| June 14, 2013 11:43 PM
AS/400 administration, AS/400 TCP/IP
SQL Error: Primary filegroup is full
Is the data file set to unrestricted growth ? (on your database properties->files check the ‘Autogrowth’ values) ————————-
View Answer
| June 14, 2013 4:01 PM
SQL Server, SQL Server error messages, SQL Server performance, SQL Server performance tuning
Is the data file set to unrestricted growth ? (on your database properties->files check the ‘Autogrowth’ values) ————————-
View Answer
| June 14, 2013 4:01 PM
SQL Server, SQL Server error messages, SQL Server performance, SQL Server performance tuning
Error while using STRSQL
There is no RIGHT function in SQL only a LEFT. Your best bet is to use a SUBSTR function if the field is an exact length to extract the last 6 positions Example – Select SUBSTR(gmans,strpos,6)from f0901 where strpos is a numeric starting position. ======================================================= Note that RIGHT() is a scalar function available in DB2 [...]
View Answer
| June 14, 2013 5:08 PM
AS/400
There is no RIGHT function in SQL only a LEFT. Your best bet is to use a SUBSTR function if the field is an exact length to extract the last 6 positions Example – Select SUBSTR(gmans,strpos,6)from f0901 where strpos is a numeric starting position. ======================================================= Note that RIGHT() is a scalar function available in DB2 [...]
View Answer
| June 14, 2013 5:08 PM
AS/400
What is the difference between SAP r/3 4.7 and ECC 6.0 for functional module
Hi For any version or upgrade, you can find release notes. This would be the starting point. then go through the individual components to understand further. It is difficult to go through here the whole differences. As a functional consultant, it would not be a problem to do the configuration in ECC 6 or 5 [...]
View Answer
| June 14, 2013 4:48 AM
SAP ECC 6, SAP R/3, SAP R/3 4.7
Hi For any version or upgrade, you can find release notes. This would be the starting point. then go through the individual components to understand further. It is difficult to go through here the whole differences. As a functional consultant, it would not be a problem to do the configuration in ECC 6 or 5 [...]
View Answer
| June 14, 2013 4:48 AM
SAP ECC 6, SAP R/3, SAP R/3 4.7
AS/400 Overlay Problem
You should be changing the Overlay with the new object while compiling the printer file. You can find the below parameters on CRTPRTF command. <pre> Front side overlay: Overlay . . . . . . . . . . . *NONE Name, *NONE Library . . . . . . . . . . Name, [...]
View Answer
| June 14, 2013 9:05 AM
AS/400 v5r4, print overlays
You should be changing the Overlay with the new object while compiling the printer file. You can find the below parameters on CRTPRTF command. <pre> Front side overlay: Overlay . . . . . . . . . . . *NONE Name, *NONE Library . . . . . . . . . . Name, [...]
View Answer
| June 14, 2013 9:05 AM
AS/400 v5r4, print overlays
AS/400 overlay form problem
I would reduce the left and top margins in Word and run through the whole prcess again. Err down and to the left .. maybe that should be increase the left margin and decrease the top margin. Phil
View Answer
| June 14, 2013 9:18 PM
AS/400 printing, Microsoft Word, Overlays, Word 2003
I would reduce the left and top margins in Word and run through the whole prcess again. Err down and to the left .. maybe that should be increase the left margin and decrease the top margin. Phil
View Answer
| June 14, 2013 9:18 PM
AS/400 printing, Microsoft Word, Overlays, Word 2003
