|
The following tech note might shed some light.... http://www.support.lotus.com/sims2.nsf/802ee480bdd32d0b852566fa005acf8d/b6e2a1bbe7d0aec885256681004fc946?OpenDocument John Venezia jwysocki@domino.danielwo odhead.com To: DOMINO400@midrange.com Sent by: cc: domino400-owner@UUCPHOST Subject: Re: DbColumn error with AS/400 DB2 .MCS.NET ODBC 05/31/2000 06:58 PM Please respond to DOMINO400 Rob -- Currently this application runs locally, WIN95 client. I set up a Client Access System DSN ODBC driver through the WIN95 control panel, that's the one I'm using. I also have an RDB Directory Entry on the AS/400. This code is in a button(hotspot), not an agent. I followed the example from an article in the AS/400 Experts Journal titled "Connecting Domino and DB2 with ODBC". Rob Berendt <rob@dekko.com> To: DOMINO400@midrange.com Sent by: cc: owner-domino400@mi Subject: Re: DbColumn error drange.com with AS/400 DB2 ODBC 05/31/2000 04:38 PM Please respond to DOMINO400 Is this agent running on the server (RunOnServer), or, locally? Trying to see if you're using OS/400's native ODBC or an ODBC set up on your client. If on the server did you do the WRKRDBDIRE and add the local entry? jwysocki@domino.danielwoodhead.com on 05/31/2000 03:13:12 PM Please respond to DOMINO400@midrange.com@Internet To: DOMINO400@midrange.com@Internet cc: Fax to: Subject: DbColumn error with AS/400 DB2 ODBC When trying to use the following formula in a button, the error <Data Access Application Layer>Could not execute @db function occurs. I am trying to provide a list of Item Numbers for the user to choose from. Any help is appreciated. Release 5.0.2c, platform AS/400. FIELD QHItem := @Prompt([OKCANCELLIST]; "Select an Item"; "Select an Item from the list below..."; ""; "":@DbColumn("ODBC":"NOCACHE";"MYAS400DSN"; "MyUserCode";"MyPassWord";"AS400Library.File";"FieldName"));All TIA! +--- | This is the Domino/400 Mailing List! | To submit a new message, send your mail to DOMINO400@midrange.com. | To subscribe to this list send email to DOMINO400-SUB@midrange.com. | To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: meechamw@ptd.net +--- +--- | This is the Domino/400 Mailing List! | To submit a new message, send your mail to DOMINO400@midrange.com. | To subscribe to this list send email to DOMINO400-SUB@midrange.com. | To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: meechamw@ptd.net +--- +--- | This is the Domino/400 Mailing List! | To submit a new message, send your mail to DOMINO400@midrange.com. | To subscribe to this list send email to DOMINO400-SUB@midrange.com. | To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: meechamw@ptd.net +--- +--- | This is the Domino/400 Mailing List! | To submit a new message, send your mail to DOMINO400@midrange.com. | To subscribe to this list send email to DOMINO400-SUB@midrange.com. | To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: meechamw@ptd.net +---
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.
midrange.com
