Error 720 Ls Do Odbc
when running LSXODBC agent lei; LSXODBC; agent; HTTP; errors; error; Error 720; could not complete the requested operation; Error in ODBC Connection; odbc; Error in ODBC; ResultSet Technote (troubleshooting) Problem In Lotus Enterprise Integrator (LEI), when running a LSXODBC agent over HTTP, you receive one of the following errors intermittently: "Error 720- LS:DO- ODBC could not complete the requested operation. Error in ODBC Connection." or "Error in ODBC ResultSet: LS:DO- ODBC could not complete the requested operation." Cause This situation occurs when the LSXODBC agent contains a disconnect to the datasource which is not preceded by a "close" of the ResultSet class. Resolving the problem The Disconnect method is part of the ODBCConnection Class and the Close Method is part of the ODBCResutSet Class. A "Disconnect" severs you from the datasource while a "Close" terminates the ResultSet. To correct this issue, you should always close the ResultSet before disconnecting the datasource. Replace the end text, "con.disconnect", as follows: result.Close(DB-Close) con.disconnect Document information More support for: IBM Enterprise Integrator for Domino ODBC Software version: 7.0, 8.0, 8.5 Operating system(s): AIX, IBM i, Linux, Solaris, Windows Reference #: 1515245 Modified date: 2013-10-12 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Training Support Forums & community Events Rational Tivoli WebSphere Java technology Linux Open source SOA and Web services Web development XML My developerWorks About dW Submit content Feedback developerWorks>Lotus>Forums & community>Notes/Domino 6 and 7 Forum Notes/Domino 6 and 7 Forum LS:DO- ODBC could not complete the requested operation Sign in to participate Previous Next LS:DO- ODBC could not complete the requested operation Posted by Videen Nandankar on 13.Oct.10 at 07:15 AM using a Web browserCategory: Domino DesignerRelease: 7.0.2 FP1Platform: Windows XP Hello friends, I am facing error "LS:DO- ODBC could not complete the http://www.ibm.com/support/docview.wss?uid=swg21515245 requested operation " Error 720. I am trying to access oracle database and getting this error. I haven't set ODBC connectivity for SQL in my system. Is this causing the error. Please help. Thanks! Return to top LS:DO- ODBC could not complete the ... (Videen Nandanka... 13.Oct.10) . . RE: LS:DO- ODBC could not complete ... (Vinit Tyagi 14.Oct.10) . . . . RE: LS:DO- ODBC http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllFlatWeb/744a8833810530c3852577bb003dd7e3?OpenDocument could not complete ... (Videen Nandanka... 19.Oct.10) Document options Print this page Search this forum Forum views and search Date (threaded) Date (flat) With excerpt Author Category Platform Release Advanced search Sign In or Register Sign in Forgot your password? Forgot your user name? Create new registration RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support IBM Support Portal - Lotus software Lotus Support documents Lotus support by product Lotus support downloads Lotus support RSS feeds Wikis Wikis IBM Composite Applications IBM Mashup Center IBM Connections IBM Connections Cloud Developers IBM Docs IBM Forms IBM Mobile Connect IBM Sametime IBM SmartCloud for Social Business IBM Web Experience Factory Lotus Domino Lotus Domino Designer Lotus Expeditor Lotus Foundations Lotus iNotes Lotus Instructor Community Courseware Lotus Notes Lotus Notes & Domino Application Development Lotus Notes Traveler Lotus Protector Lotus Quickr Lotus Symphony IBM Web Content Manager WebSphere Portal Lotus Forums Lotus Forums Notes/Domino 9.0 Notes/Domino 8.5 + Traveler Notes/Domino XPages development forum Notes/Domino 8 Notes/Domino 6 and 7 IBM Connections IBM Mobile Connect IBM Sametime IBM Sma
Training Support Forums & community Events Rational Tivoli WebSphere Java technology Linux Open source SOA and http://www-10.lotus.com/ldd/46dom.nsf/0/87c9f05285447d9485256c40004ea21e Web services Web development XML My developerWorks About dW Submit content Feedback developerWorks>Lotus>Forums & community>Notes/Domino 4 and 5 Forum Notes/Domino 4 and 5 Forum Error 720 : https://www.experts-exchange.com/questions/21491538/Problem-connecting-to-database.html LS:DO- ODBC could not complete the requested operation. at line number 12 Error 720 : LS:DO- ODBC could not complete the requested operation. at line number 12Posted error 720 by Daniela Invernici on 26.Sep.02 at 10:18 AM using a Web browserCategory: Domino Designer -- LS:DORelease: 5.0.4aPlatform: Windows 2000 Hi ! I have a scheduled agent that should gather on a regular basis data from an MS Access database. The agent work properly when it is manually run but always stop at line 12 with error 720 ls the following error message : Error 720 : LS:DO- ODBC could not complete the requested operation. at line number 12 What should I do ? I don't know where to start my investigations. Thanx Daniela My code (part of it): Set ses = New NotesSession Set db = ses.CurrentDatabase Set con = New ODBCConnection Set qry = New ODBCQuery Set result = New ODBCResultSet Set qry.Connection = con con.SilentMode=True ---line 12--->Call con.ConnectTo("PRODFEATSET","GTS") con.Disconnect Return to top Error 720 : LS:DO- ODBC could not c... (Daniela Inverni... 26.Sep.02) . . RE: Error 720 : LS:DO- ODBC could n... (Santas Lei 26.Sep.02) . . RE: Error 720 : LS:DO- ODBC could n... (Daniela Inverni... 26.Sep.02) . . . . RE: Error 720 : LS:DO- ODBC could n... (Luke Kolin 26.Sep.02) Document options Print this page Search this forum Forum views and search Date (threaded) Date (flat) With excerpt Author Category Platform Release Advanced search RSS feeds All forum posts RSS
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Problem connecting to database Want to Advertise Here? Solved Problem connecting to database Posted on 2005-07-14 Lotus IBM 1 Verified Solution 4 Comments 1,727 Views Last Modified: 2013-12-18 Hello, Some Lotus script was written to connect to an Oracle database via ODBC. The call procedure has been working fine. However yesterday we started to recieve the follwoing error .... Error occurred .... 720 : LS:DO -ODBC could not complete the requested operation. We have proved the ODBC connection words as we can connect via Excel and run our query, and apparently there has been no changes made to the platforms. Macafee has been the only thing that has been run recently. Has anybody got any ideas what we could try ? Thanks Alistair 0 Question by:Alistair_Williams Facebook Twitter LinkedIn Google LVL 46 Active today Best Solution bySjef Bosman You could start finding out where the error occurred, by running the code from the debugger: File/Tools/Debug LotusScript. Then start the procedure locally, so if it's an agent, go to the agent list, Go to Solution 4 Comments LVL 46 Overall: Level 46 Lotus IBM 44 Message Active today Accepted Solution by:Sjef Bosman2005-07-14 You could start finding out where the error occurred, by running the code from the debugger: File/Tools/Debug LotusScript. Then start the procedure locally, so if it's an agent, go to the agent list, right-click on it and select Run. Only if there are On Error statements in the code, we have a problem. Let the agent run until the error occurs. Then report here the lines before the error. It's interesting to know whether you're in the middle of a lot of processing or right at the start. 0 LVL 63 Overall: Level 63 Lo