Windows 7 printing
I am getting error ” windows cannot connect to the printer. Operation failed with error 0×00000002″ Both the pc’s are in one domain. this problem is only with one pc in domain but for the same pc expect printing sharing the folder is OK.
Answer Question
| July 26, 2011 5:35 AM
PC/Windows Connectivity, Windows 7, Windows 7 error messages, Windows 7 in 2010, Windows 7 Printing
I am getting error ” windows cannot connect to the printer. Operation failed with error 0×00000002″ Both the pc’s are in one domain. this problem is only with one pc in domain but for the same pc expect printing sharing the folder is OK.
Answer Question
| July 26, 2011 5:35 AM
PC/Windows Connectivity, Windows 7, Windows 7 error messages, Windows 7 in 2010, Windows 7 Printing
transferring files from iSeries to PC
Does anyone know of a way to transfer a file from the iSeries to a pc using CLP or RPGILE? I do not want the user to have to run a client access transfer. I would like the user to be unaware that this transfer has been done. thanks
Answer Question
| December 3, 2007 2:48 PM
Application development, CLP, PC/Windows Connectivity
Does anyone know of a way to transfer a file from the iSeries to a pc using CLP or RPGILE? I do not want the user to have to run a client access transfer. I would like the user to be unaware that this transfer has been done. thanks
Answer Question
| December 3, 2007 2:48 PM
Application development, CLP, PC/Windows Connectivity
Source Modified User
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question
| December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question
| December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
CA Express download from iSeries to excel
I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left. Does [...]
Answer Question
| June 14, 2007 9:57 AM
AS/400, PC/Windows Connectivity, Software
I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left. Does [...]
Answer Question
| June 14, 2007 9:57 AM
AS/400, PC/Windows Connectivity, Software
Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
Tracking Changes to Files
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]
Answer Question
| August 13, 2007 5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]
Answer Question
| August 13, 2007 5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
browser
I have to invoke a browser from as/400 with authentication by sending sensitive information as paremeters. The browser will take tbe parameters and get the data from i-series and display the information in the browser. any help in how to invoke the browser with paramaters would be helpful as soon as possible.
Answer Question
| March 29, 2007 7:09 AM
AS/400, PC/Windows Connectivity
I have to invoke a browser from as/400 with authentication by sending sensitive information as paremeters. The browser will take tbe parameters and get the data from i-series and display the information in the browser. any help in how to invoke the browser with paramaters would be helpful as soon as possible.
Answer Question
| March 29, 2007 7:09 AM
AS/400, PC/Windows Connectivity
Trying to publish a Webfacing Project
Using WebSphere Development Studio I’ve created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting the project to a directory on [...]
Answer Question
| March 16, 2007 11:48 AM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE, Web development
Using WebSphere Development Studio I’ve created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting the project to a directory on [...]
Answer Question
| March 16, 2007 11:48 AM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE, Web development
Copy files from other systems into IFS folder via Windows Explorer
How can we copy xls or txt files from other systems into IFS folder using Windows Explorer? Using iSeries v5r4. We can display files from IFS folder using internet explorer. What type of config do we need to do? What type of security access do users need to have? Can you send documentation on this?
Answer Question
| March 14, 2007 5:02 PM
PC/Windows Connectivity
How can we copy xls or txt files from other systems into IFS folder using Windows Explorer? Using iSeries v5r4. We can display files from IFS folder using internet explorer. What type of config do we need to do? What type of security access do users need to have? Can you send documentation on this?
Answer Question
| March 14, 2007 5:02 PM
PC/Windows Connectivity
Copy file from windows to iSeries Optical Library using navigator
We have a network folder on our Windows workstation that contains word documents that we backup yearly. I have created a bat file to copy out just the 2006 files and put them in individual monthly folders (Jan2006, Feb2006, etc.). I would like to copy these folders to our optical library (3995-c42)for backup/Storage on our [...]
Answer Question
| February 9, 2007 4:22 PM
AS/400, PC/Windows Connectivity
We have a network folder on our Windows workstation that contains word documents that we backup yearly. I have created a bat file to copy out just the 2006 files and put them in individual monthly folders (Jan2006, Feb2006, etc.). I would like to copy these folders to our optical library (3995-c42)for backup/Storage on our [...]
Answer Question
| February 9, 2007 4:22 PM
AS/400, PC/Windows Connectivity
Windows Scheduling iSeries Data Transfer
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]
Answer Question
| June 18, 2010 3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]
Answer Question
| June 18, 2010 3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
Using Client Access while on VPN
We have just converted from a iSeries 270 V5 R1 to a 520 V5 R3. The system values on both systems are the same. The remote users who attach to the network using a VPN then starting Client Access no longer work. The 270 was not defined in our firewall and we were able to [...]
Answer Question
| December 29, 2009 3:46 PM
AS/400, PC/Windows Connectivity
We have just converted from a iSeries 270 V5 R1 to a 520 V5 R3. The system values on both systems are the same. The remote users who attach to the network using a VPN then starting Client Access no longer work. The 270 was not defined in our firewall and we were able to [...]
Answer Question
| December 29, 2009 3:46 PM
AS/400, PC/Windows Connectivity
FTP from iSeries to PC
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection Any idea where I am going wrong please?
Answer Question
| January 18, 2007 10:38 AM
Application development, AS/400, PC/Windows Connectivity
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection Any idea where I am going wrong please?
Answer Question
| January 18, 2007 10:38 AM
Application development, AS/400, PC/Windows Connectivity
iseries Client Access
We have several PC workstation with “static” assigned workstation ID’s. Lately these static ID’s have been showing up in the “pool” and being assigned to whoever happens to start a client access session, instead of the default QPADEVxxxx workstation ID. This then causes the person who “owns” the static ID to not be able to [...]
Answer Question
| January 15, 2007 5:51 PM
AS/400, PC/Windows Connectivity
We have several PC workstation with “static” assigned workstation ID’s. Lately these static ID’s have been showing up in the “pool” and being assigned to whoever happens to start a client access session, instead of the default QPADEVxxxx workstation ID. This then causes the person who “owns” the static ID to not be able to [...]
Answer Question
| January 15, 2007 5:51 PM
AS/400, PC/Windows Connectivity
Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]
Answer Question
| January 7, 2007 10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]
Answer Question
| January 7, 2007 10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]
Answer Question
| October 14, 2010 10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]
Answer Question
| October 14, 2010 10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
Incoming Remote Command on Windows XP
I’ve been able to find lots of entries on the IBM site for Incoming Remote command and SE, ME, NT and 2000 but there is something different with XP that prevents it from working. Has anyone been able to make the incoming remote command work to an PC running XP?
Answer Question
| December 28, 2009 3:30 PM
AS/400, PC/Windows Connectivity
I’ve been able to find lots of entries on the IBM site for Incoming Remote command and SE, ME, NT and 2000 but there is something different with XP that prevents it from working. Has anyone been able to make the incoming remote command work to an PC running XP?
Answer Question
| December 28, 2009 3:30 PM
AS/400, PC/Windows Connectivity
Renaming a file in the IFS directory
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, [...]
Answer Question
| December 26, 2009 3:53 PM
Application development, AS/400, CLP, DataCenter, PC/Windows Connectivity
I am receiving a file daily in an IFS directory, I manually copy the file to a library using the CPYFRMSTMF command. I want to automate the process so that it will be done every day at a specific time. The challenge is that the file name in the IFS directory is different every day, [...]
Answer Question
| December 26, 2009 3:53 PM
Application development, AS/400, CLP, DataCenter, PC/Windows Connectivity
iSeries Access and 5250 Session Disconnects
I have a client with a Dell Laptop that is connecting to an i5 520 system with iSeries Access V5R3. The 5250 sessions will not stay connected. All other PC and telnet devices have no problems stating connected. I believe the issue is associated with the Microsoft updates associated with the Laptop. Has anyone had [...]
Answer Question
| April 16, 2012 1:47 PM
AS/400, PC/Windows Connectivity
I have a client with a Dell Laptop that is connecting to an i5 520 system with iSeries Access V5R3. The 5250 sessions will not stay connected. All other PC and telnet devices have no problems stating connected. I believe the issue is associated with the Microsoft updates associated with the Laptop. Has anyone had [...]
Answer Question
| April 16, 2012 1:47 PM
AS/400, PC/Windows Connectivity
Db2/AS400 library connecting via oledb in vb.net
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field “Enter the initial catalog to use” I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors [...]
Answer Question
| November 25, 2006 8:40 PM
DB2 Universal Database, PC/Windows Connectivity
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field “Enter the initial catalog to use” I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors [...]
Answer Question
| November 25, 2006 8:40 PM
DB2 Universal Database, PC/Windows Connectivity
