Lotus Notes Odbc Error 720
LSXODBC; OLEDB; MSSQL; 80004005; script connection; script; code; lotusscript; ODBC; LSXLC; stopped working; errors; Error 500; HTTP Web Server; Exception; Agent Did not complete within the time limit; Error in Initialize fn; 720; ODBC could not complete the requested operation; line 13; connector; Server does not exist or access denied; Line 25 Technote (FAQ) This document applies only to the following language version(s): English Question A script connection to ODBC via LSXODBC and LSXLC stopped working with the following errors: General web server error: "Error 500: HTTP Web Server: Lotus Notes Exception - Agent Did not complete within the time limit." LS:DO specific error: "Error in Initialize fn, Error #720 Error msg: LS:DO - ODBC could not complete the requested operation. Error line no 13 Line 13 -> If con.ConnectTo("IBM_SQL_Test","XXXXX", "YYYYYY") Then LSXLC using OLEDB connector specific error: Error in Initialize fn, Error #12325 Error msg: Error: ErrorRecord: HResult: 0x80004005 Description: [DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied Error line no 25. Line 25 -> connect.Connect Answer This problem can arise due to many factors. Most of these factors are outlined in Microsoft technical document #328306 at http://support.microsoft.com/kb/328306/en-us. Running a connectivity test from the SystemDSN (locally) from the Lotus Domino server to the SQL server worked each time, proving that the SystemDSN for the MS SQL ODBC datasource was finding the SQL server. However, when accessing via HTTP, LotusScript was returning SQL-specific error messages that pointed to a possible connectivity problem. In this particular case, access was through a web browser (web-based application) and the URL was being redirected by an internal DNS server to a failover server that did not have the appropriate databases. All servers must have the backend datasouce set up identically. Likewise, any required databases must also be located on each server. Once the internal DNS was corrected to point the primary server, all agents started functioning correctly. Related information Document information More support for: IBM Domino Software version: 6.0, 6.5, 7.0, 8.0 Operating system(s): Windows Software edition: All Editions Reference #: 1280094 Modified date: 08 January 2009 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 4 and 5 Forum Notes/Domino 4 and 5 Forum Error 720 : 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 by http://www-01.ibm.com/support/docview.wss?uid=swg21280094 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 http://www-10.lotus.com/ldd/46dom.nsf/0/87c9f05285447d9485256c40004ea21e 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 RSSAll m
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 4 http://www-10.lotus.com/__852565590065a86d.nsf/0/977869064221b03885256c40005702c1?OpenDocument and 5 Forum Notes/Domino 4 and 5 Forum RE: Error 720 : LS:DO- ODBC could not complete the requested operation. at line number 12 RE: Error 720 : LS:DO- ODBC could not complete the https://forums.manning.com/posts/list/2022.page requested operation. at line number 12Posted by Luke Kolin on 26.Sep.02 at 11:50 AM using a Web browserCategory: Domino Designer -- LS:DORelease: 5.0.4aPlatform: Windows 2000 Do you have a System DSN set up on the lotus notes server to point to the database? Cheers! Luke 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 lotus notes odbc 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 RSSAll main topics RSSMore Lotus RSS feeds Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support Product support pages index Search knowledge base (Technotes) Search support downloads Lotus Support RSS Wikis IBM Composite Applications IBM Mashup Center IBM Connections 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 Notes/Domino 9.0 Notes/Domino 8.5 + Traveler Notes/Domino XPages development forum Notes/Domino 8 Notes/Domino 6 and 7 Notes/Domino 4 and 5 IBM Connections IBM Forms IBM Mobile Connect IBM Sametime IBM SmartCloud Notes IBM SmartCloud Meetings IBM Web Content Manager Lotus Domino Document Manager Lotus e-learning Lotus Enterprise Integration Lotus Expeditor Lotus Protector Lotus Quickr Lotus SmartSuite Lotus Symphony Lotus Symphony Developer Toolkit Support Lotus Workflow About IBM Privacy Contact Terms of use
by aspatton] One obvious workaround is using SQL (INSERT) instead of the UpdateRow method. I haven't had any experience with the error, but I did find this in the Notes knowledgebase: ---------------------------------------------------------- UpdateRow Method Returns a "720 LSO - ODBC" Error Writing to an Access Database Problem: You are attempting to update a Microsoft Access 97 database via an LSO script that uses the UpdateRow method. The update fails, however, and the script generates the following error: "Result Set: Error 720 LSO - ODBC could not complete the requested operation [Microsoft] [ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO statement" Solution: This issue occurs when there is a field (column) called "NOTE" in the Access database. This issue has been reported to Lotus Quality Engineering. Workarounds: There are two ways to work around this issue: 1. In Access, rename the field to something other than NOTE. or 2. Avoid using the UpdateRow statement and build the SQL statement to insert the data. This approach is illustrated in the following sample script. Sample Script: Sub Click(Source As Button) On Error Goto erroreodbc Dim con As New odbcconnection Dim qry As New odbcquery Dim res As New odbcresultset Dim status As Variant status=con.connectto("DB3") Set qry.connection=con 'Choose one of the following: 'THE FOLLOWING GENERATES THE ERROR: ' qry.sql="SELECT * FROM TABLE1" ' Set res.query=qry ' res.execute ' ris=res.addrow ' status=res.setvalue(1,"Test") ' status=res.setvalue(2,"Test1") ' status=res.setvalue(3,"Test2 ") ' status=res.updaterow 'THE FOLLOWING WORKS CORRECTLY qry.sql="INSERT INTO TABLE1 VALUES ('Test','Test1','Test2') set res.query.qry status=res.execute 'The following is always needed. res.close(DB_CLOSE) con.disconnect erroreodbc: If res.GetError <> DBstsSuccess Then res.Close(DB_CLOSE) Msgbox "Result Set: Error " + Str$(res.GetError) + " " + res.GetErrorMessage + " " + res.GetExtendedErrorMessage End If End Sub ---------------------------------------------------------- Tony. import-bot (20212) Offline Oct 29, 2000 @ 10:00 PM #2 [Originally posted by h-ramos] I am trying to write a manually activated agent to update a MS-SQL server with data from a Notes database