Windows to AS/400, iSeries to Windows (ODBC, Excel, SQL Server, .Net, etc...) Tips, Techniques, and Articles
Return to list of categories.
- .NET for Your System i
- .NET Integration with DB2 UDB for iSeries by Jarek Miszczyk
- .NET Web Services - You can easily construct a .NET application that can take advantage of a valuable information resource--.NET Web Services.
- A C# Primer for RPG Programmers
- A Pop-Up with Options By Craig Pelkie
- Accessing AS/400 data using Excel ODBC drivers
- Accessing Data on Microsoft SQL Server from OS/400
- Accessing i Data from MS SQL Server by Joe Pluta
- Accessing iSeries Data with ODBC by Chris Peters
- Add Column Headings to Your Export Files by Michael Sansoterra
- Advanced DB2 for i Data Access Techniques with .NET
- Advanced DB2 for i Data Access Techniques with .NET - Reader Feedback
- An Easy Way to Encrypt a File Before Transferring It by Scott Klement
- Analyze DB2/400 Data with Excel by Chris Peters
- Another Way to Open a Browser with STRPCCMD by Scott Klement
- ASP.NET to iSeries Socket Server by Mike Faust
- Auto-launch a PC application from the AS/400
- Automate E-Mail Operations with Outlook and VBA
- Automating Data Transfer by Using the Batch Transfer for Microsoft Windows
- Basics first : UDL Test
- Build Pivot Tables over DB2 Data
- Bypassing the 65,000 row limit in Excel via the iSeries
- Call iSeries Programs and Get Back Parameters from VB.NET by Scott Klement
- Calling a program on an iSeries with .net
- Calling AS/400 (AS400) RPG Programs From ASP.NET
- Calling AS/400 (AS400) RPG Programs/APIs From .NET
- Calling CL Programs as Stored Procedures (VB and VBScript examples) by Howard Arner
- Calling CL Programs from VB.NET using V5R2
- Calling IBM iSeries RPG Programs with API Calls
- Calling IBM iSeries RPG Programs with SQL Stored Procedures
- Changing ODBC Sign-On Pop Up Values
- Client/Server Performance, Part 1: Blocking
- code.ExtendYourself by Craig Pelkie
- Configure ODBC to access iSeries(AS/400) system
- Connecting Open Office to the iSeries
- Connecting to DRDA Databases from the iSeries by Michael Ryan
- Convert AS/400 Data into XML by Tahir Malik
- Converting iSeries Spool Files to Excel - Top 10 Issues Resolved! (Free whitepaper)
- Copy a physical file to Excel in 9 lines of Python
- Copy DB file to Excel format
- Copy IFS data from the iSeries to a Windows server
- Copy source code from a PC to the AS/400 (iSeries)
- Copying Data to MS Excel by Robert Cozzi, Jr.
- CPYTOIMPF Doesn't Create Column Headers, But You Can
- Create Excel Documents with Embedded SQL by Scott Klement
- Create Excel Spreadsheets From DB2 Data With PHPExcel
- Creating Spreadsheets with an Open-Source Utility by Michael Ryan
- Cut Your Development Effort with DB2 Development Add-in for .NET by Jarek Miszczyk
- Data Entry Robots by Michael Sansoterra
- DB2 Integration with SQL Server 2005, Part 1: Linked Server Enhancements
- DB2 Integration with SQL Server 2005, Part 2: CLR Integration by Michael Sansoterra
- DB2/400 to Excel via POI
- Db2XTool, an utility able to convert database files to PC formats (.csv, .html, .txt, .xml) and to display the results via EXCEL, Internet Explorer, or Notepad.
- Delimit Data on the IBM i the Easy Way
- Detect Host OS and Client Version Levels within Client Software by Michael Sansoterra
- Determining Current Windows User, OpsNav Prompting
- Different ways to access iSeries data with .NET
- Display Operations Navigator from a 5250 Green Screen by Shannon O'Donnell
- Displaying Dates in Excel by Robert Cozzi, Jr.
- Download Physical Files Using Microsoft Excel by Paul Weyer
- Easily Create Excel Spreadsheets from Your IBM i Using SSIS
- Example Visual Basic code for moving csv data to the iSeries
- Excel Flies Higher with JExcelApi by Giuseppe Costagliola
- Excel on the Fly by Giuseppe Costagliola
- Exporting DB2/400 Dates to Excel by Jeff Haddix
- Extend iSeries Data to Microsoft Excel Efficiently and Transparently by Tahir Malik
- External Stored Procedures and Client/Server Error Messages by Michael Sansoterra
- Five Ways to Access IFS Data from a Windows PC without FTP
- Format 5250 screens into Microsoft Word
- FROG: PC-based SQL for DB2 for i
- From Many, One: Using Enumerations By Craig Pelkie
- Generic Database Access with .NET 2.0
- Get a 'Load-All' Web Subfile Up and Running in Minutes by Craig Pelkie
- Get Data from MS SQL Server 2005 on Your i5 by Muhammad Ilyas
- Get Windows Networking Name in a Program by Scott Klement
- Getting data off the iSeries part 2 (.NET)
- Getting Started with SQL Server Integration Services by Craig Pelkie
- Getting the List by Craig Pelkie
- Getting Up to Speed with AddBatch
- Going Virtual with Microsoft Virtual PC 2007 by Craig Pelkie
- Guru: IBM i, .Net, and XMLSERVICE Program and Subprocedure Calls
- Harnessing Your ODBC Users with Exit Programs by Bob Butcher
- Heads Up! Additional Configuration Required for Windows 7/Windows Server 2008 R2
- Heterogeneous Data Access for iSeries Applications - Version 2
- How to Call a Stored Procedure from Excel by Howard F. Arner, Jr.
- How to Call a Stored Procedure from Excel, Part 2 by Howard F. Arner, Jr.
- How to Excel with RPG and Java
- How to Excel with RPG and Java, Part 2
- How to Excel with RPG and Java, Part 3
- How to save time using the CPYTOPCD and CPYFRMPCD commands by Ron Turull
- How to Update an HSSF Spreadsheet
- How to Use a Context Menu Strip with a DataGridView by Craig Pelkie
- How to Use CGI for Program-to-Program Communications
- How to Use External Stored Procedures with .NET Applications by Craig Pelkie
- How to video: Access data on iSeries using ADO.NET
- HSSF Fills and Colors
- HSSF Word Wrapping
- IBM i and .Net Connectivity With XMLSERVICE
- IBM provided API Examples
- Integrate Excel with Your Databases for Easy User Access
- iSeries Access .NET Data Provider
- It's About Time by Craig Pelkie
- JExcel Revisited
- Just Push a Button to Get AS/400 Query Results in Excel by G. Wayne Hawks
- Line Up Windows Controls with TableLayoutPanel By Craig Pelkie
- Load a ComboBox from a Stored Procedure by Craig Pelkie
- Load a Spreadsheet from a DB2/400 Database
- Load a Spreadsheet from a DB2/400 Database: Part 2
- Load a Spreadsheet from a DB2/400 Database: Part 3
- Make DB2 Data Downloads Easy with Start CGI SQL Session (STRCGISQL) by Steven Goetjen
- Making the Most of Excel Web Query by Mike Faust
- Mapping a Network Drive from the IBM i
- Maximize ODBC Performance in Microsoft Office by Brent Nelson
- MERGE DB2 Data to SQL Server 2008 by Michael Sansoterra
- Merge iSeries Data with Word XP by Brian Singleton
- Merging DB2/400 Data with a Microsoft Word Document by Shannon O'Donnell
- Microsoft .NET 2.0 for System i Developers: Building Windows Forms Using the DataGridview Control by Michael Sansoterra
- Microsoft and IBM Play Nice - What can .NET technology do for the System i developer? by Richard Schoen
- Microsoft Computing: Including a Web Service in Excel--It's Crazy Easy! by Brian Singleton
- Microsoft OLE DB Driver for DB2 (Microsoft SQL Server 2005)
- Microsoft Virtualization for the i Guys, Revisited by Michael Sansoterra
- Microsoft's OLE DB/ADO Technology by Chris Peters
- Move / Convert Data from Excel Spreadsheet to DB2/400
- Move Data to Excel or CSV Format by Robert Cozzi, Jr.
- New Data Transfer ActiveX Automations in Express by Jeremy Bauer
- New POI Release Brings Excel's XLSX Support to RPG
- ObjectDataSource Controls Can Take Charge in ASP.NET Web Applications by Craig Pelkie
- ODBC Security by Chris Peters
- ODBC Troubleshooting for iSeries
- Pack on the Calories with ListView Pudding by Bob Butcher
- Parse i5/OS Job Logs into CSV by Craig Pelkie
- Parse or TryParse by Craig Pelkie
- Parsing an Excel Spreadsheet Part 2: Handling Dates by Scott Klement
- Parsing an Excel Spreadsheet with RPG and Java by Scott Klement
- PC - ODBC - AS/400
- Prevent users with ODBC access to the AS400 from UPDATE or INSERT of data.
- Preventing users from uploading data
- Produce Dashboards with MS Excel by Paul Holm
- Programmatically Import Excel Worksheets Using IBM's ActiveX Object Library
- Programmatically Retrieve Defined System i Names by Michael Sansoterra
- Programming Subfiles Using VB.NET by Richard Schoen
- QNTC: Opening Windows NT to the AS/400 by Shannon O?Donnell
- Query Active Directory from the iSeries by Michael Sansoterra
- Querying iSeries DB2 with ADO.Net
- Quick Utility to Share NetServer Folders by Scott Klement
- Reading an iSeries table in C# (with video)
- Record-Level Access Revisited by Christopher J. Devous
- Redirect ODBC to a separate subsystem by David Vasta
- Remove Trailing Blanks from Legacy Columns with the IBM OLE DB Providers
- Returning Result Sets and Parameters Using ADO
- Rev Up "i" Reporting with SQL Server 2008 Reporting Services
- RPG Beans from VB Apps
- RPG To Desktop
- Run SQL with output to an Excel file
- Select and Omit Records from a CSV File
- Serving Up Spreadsheets by Paul Tuohy
- Set the Paper Size with HSSF by Scott Klement
- Set Windows Default Printer from a CL by Scott Klement
- Share (and Save) Your Settings by Craig Pelkie
- Share Application Data with the AppDomain
- Share the Data Using AppDomain by Craig Pelkie
- Share the View with SharedView by Craig Pelkie
- Sprinkle GUI on Your Green Screen Salad by Bob Butcher
- SQL to CSV or XML on the fly by Giuseppe Costagliola
- Start any PC program from a Green Screen by Booth Martin
- Stored Procedures and the Multiple Result Sets Alternative by Craig Pelkie
- Stream Files and End-of-Line Delimiters, Take Three
- System i Developers and .NET 2.0, Part 2: Web Development Using ASP.NET AJAX by Michael Sansoterra
- System i Developers and .NET 2.0: ASP.NET and the Declarative Programming Model by Michael Sansoterra
- TechTip: C# for RPGers - Start Here
- TechTip: C# for RPGers – C# and RPG Basic Data Types Compared, Part 1
- TechTip: C# for RPGers: Creating Your First C# Program and a Quick Tour of the IDE
- TechTip: C# for RPGers: Visual Studio's Code-Assistance Tools
- The Case of the Missing .NET Data Provider for i5/OS in Visual Studio 2008
- The proper way to transfer data to the iSeries by Ken Dafoe
- The Way We Word: File Transfer for Dummies by Chris Devous
- Three Keys to Better ODBC Library List Management by Joe Hertvik
- Three Steps to Mapping iSeries Data to a Windows Network Drive by Joe Hertvik
- Turning Off ODBC Journaling Is Not a Good Idea
- Turning Off ODBC Query Timeout Limits by Joe Hertvik
- Use C# to Create a Web Service Consumer Application by Craig Pelkie
- Use Prepared Statements with ADO to Access iSeries Data by Kevin Forsythe
- Use SqlDataSource and Databound Controls to Create ASP.NET Web Forms in Minutes by Craig Pelkie
- Use System Naming Convention and Library List with .NET Managed Provider by Michael Sansoterra
- Using .NET to Call iSeries Stored Procedures
- Using Different ODBC DSN Types for i5 Access
- Using RPG As Your ASP Language, Part 1 by Howard F. Arner, Jr., and Holley Davis
- Using RPG As Your ASP Language, Part 2 by Howard Arner, Jr., and Holley Davis
- Using SQL Server BI with the IBM i
- V5R4 Improvements to the i5/OS OLE DB Providers by Michael Sansoterra
- V6R1 Breathes New Life into DB2 for i5/OS .NET Provider by Jarek Miszczyk
- V6R1 Run SQL Scripts: Print and Save Result Sets by Skip Marchesani
- What TCP servers need to be started on the iSeries for ODBC functionality to work?
- Windows 7 and IBM i NetServer
- Work with the Data Queues API in .NET Applications By Craig Pelkie
- Work with the Headless Web by Craig Pelkie
- Working with Object Data Sources for Data Binding by Craig Pelkie
- Working with Visual Basic's Printer Object by Bob Butcher
- Write Your Own Custom CSV Export Utility--Without APIs by Scott Klement
- Writing Your First .NET Application by Richard Schoen
- Yet Another Way to Build a Tab-Delimited File
- Yet Another Way to Build CSV Files
