=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCH400 | Top Expert Advice April 16, 2002
Answers to your technical questions and expert advice on PC/Windows connectivity for the iSeries. More Q&As: http://search400.techtarget.com/ateAnswers/0,289620,sid3_cid371936_tax285221,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSORS: SEE HOW SIMPLE AS/400 and ISERIES DATA ACCESS CAN BE http://search400.com/r/0,,2894,00.htm?ASC400 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. Expert Questions on PC/Windows connectivity - FTP to a remote PC - DSN files causing ODBC problems - Extracting data from the iSeries 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: The 400/Windows connection - Best Web Links: PC/Windows connectivity - Featured Book: Client Access/400 Expert Reader - Tips Contest: March winners announced ___________________________________________________________________ *********** SPONSORED BY Advanced Systems Concepts***************** SEE HOW SIMPLE AS/400 and ISERIES DATA ACCESS CAN BE - IN JUST 6 SHORT MINUTES! SEQUEL ViewPoint offers a Windows-based interface for writing queries, reports, database tables, FTP, e-mailing files, reports and a whole lot more. One tool for all your iSeries data access needs! Make your job easier and improve data access throughout your organization. Download a FREE ScreenCam demo of ViewPoint at: http://search400.com/r/0,,2894,00.htm?ASC400 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FTP TO A REMOTE PC | by Shahar Mor Is it possible to FTP to a remote PC without using STRPCCMD? >> Read Shahar's response: http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid418349_tax285221,00.html >> Check out Shahar's other Q&As or submit your own PC/Windows connectivity question: http://search400.techtarget.com/ateAnswers/0,289620,sid3_cid371936_tax285221,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DSN FILES CAUSING ODBC PROBLEMS | by Shahar Mor We are gradually upgrading the PCs on our network from Client Access to Client Access Express. After the upgrade we've had trouble with ODBC connections using DSN files that have the system name. I've been able to eliminate those errors in most cases by replacing the system name with the IP address. However, any Excel spreadsheet that uses a DSN with a system originally defined retains the system name even after the DSN & query have been changed to use the IP address. What can I do? >> Read Shahar's answer: http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid446180_tax285221,00.html >> Check out Shahar's other Q&As or submit your own PC/Windows connectivity question: http://search400.techtarget.com/ateAnswers/0,289620,sid3_cid371936_tax285221,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= EXTRACTING DATA FROM THE ISERIES | by Shahar Mor Can I extract data from the iSeries 400 to a NT 4.0 or XP server (Excel, Access)? >> Read Shahar's response: http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid457892_tax285221,00.html >> Check out Shahar's other Q&As or submit your own PC/Windows connectivity question: http://search400.techtarget.com/ateAnswers/0,289620,sid3_cid371936_tax285221,00.html __________________________________________________________________ ::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS ::::::::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE 400/WINDOWS CONNECTION | Featured Topic Getting your iSeries and Windows-based machines to "talk" to each other can be challenging. The expert advice and tips we've gathered can help you with this endeavor. If you still have questions, you can always ask our experts. >>CLICK here to read featured topic: http://search400.techtarget.com/featuredTopic/0,290042,sid3_gci748420,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PC/WINDOWS CONNECTIVITY | Best Web Links You need your Windows-based PCs to connect to your iSeries 400. This section serves up several articles to help you connect your iSeries with Windows-based machines, including tips, product reviews and analysis pieces. >>CLICK here to read articles: http://search400.techtarget.com/bestWebLinks/0,289521,sid3_tax286953,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FEATURED BOOK | search400's Bookstore Title: Client Access/400 Expert Reader Author: Joe Hertvik Many of you know Joe Hertvik through Search400's administrator tips. Before he started doing that, however, he also published this book. A compilation of iSeries networking articles, it covers a range of Client Access issues as well as other networking subjects. >>CLICK here to get more information: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=1883884608&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MARCH WINNERS ANNOUNCED | Search400 tips contest Congratulations to Brad Betsworth for winning Search400's Tip of the Month contest for March. Brad won a Garmin eMap GPS and was added to our Hall of Fame for his tip: "Copy and restore spoolfiles." http://www.search400.com/tip/1,289483,sid3_gci811122,00.html Congratulations also to our runner-up winners: Sietse Witzenburg, Noel Cannon and Joe Szymanski. You may read their winning tips at http://search400.techtarget.com/tipsHallOfFame/0,289489,sid3_prz804422_cts804420,00.html NEW CONTEST FOR APRIL: This month we're giving away a Secret Agent Man Digital Seiko Watch. The Secret Agent Man Digital Seiko Watch is a high-tech digital watch has everything you'd ever want in a watch and more. Features include three alarms, chronograph, preset countdown timer, self-adjusting calendar and storage of up to 100 Internet/e-mail addresses, phone numbers or other memos. Send in your tip -- you could be our next winner. >> SUBMIT a Tip: http://www.search400.com/tipsPrize/0,289492,sid3_prz812143_cts812140,00.html _____________________________________________________________ ::::::::::::::::::: SEARCH400 CONTACTS ::::::::::::::::::: TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. _____________________________________________________________ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. _____________________________________________________________ DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. _____________________________________________________________ DAVID GABEL, executive tech editor (mailto:[EMAIL PROTECTED]) >> Send me your technical tips and tip ideas. _____________________________________________________________ GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. Unsubscribe from 'Updates on new site content' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search400.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
