|
Vladimir Bystrov wrote to midrange-l: I want to be able to use CA/400 ODBC driver in Visual Basic to connect to F8309 FASTR work file with an explicit reference to IBM file member that holds my FASTR report PC download information. I cannot figure out the ODBC connection string portion describing member name in CA/400 ODBC. I can do this with ShowCase ODBC (SELECT ... FROM LIBRARY.F8309:MEMBER). I also can create a physical file with AS/400 query or FTP and dump it to a PC, but it all requires extra steps. Does anyone have any clue how this could be done directly with CA/400 ODBC in VBA? Any help or comments are appreciated. Thanks, Vladimir Bystrov Dear Vladimir, The IBM Tech Studio portion of the IBM AS/400 Technical Support web site has some ODBC information that might help you. The URL is: http://www.as400.ibm.com/tstudio/ca400/caindex.htm Click on the ODBC selection in the list. Hope this helps, /Paul -- Paul Tykodi, Technical Director E-mail: pault@praim.com Praim Inc. Tel: 603-431-0606 140 Congress St., #2 Fax: 603-436-6432 Portsmouth, NH 03801-4019 +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.